473,322 Members | 1,494 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Autopopulate Subform data

2
Hi I have a main form in which I have linked subforms on tabs..
My problem is that I have one subform which is linked to a table which has 2 to 6 sessions in one table, we are required to fill out a feedback form for each session. So I have put hidden 6 tabs with subforms on each tab linked back to tbl_feedback.....

So far I have it set up so that when a date field next to a session number on first tab is changed it opens appropriate tab with feedback sub on it... I can get it to create a new record in feedback sub, but if I go back and change date next to session again the corrct feedback sub tab opens but shows first record in feedback tbl based on main form link... I need it to autopopulate the sub fields with data from tbl based on one value in sub.

Such as when date first changed on session 2, new Feedback ID is created 645... change session 2 date again it goes back to 638...
Jul 25 '08 #1
2 1684
PianoMan64
374 Expert 256MB
Can you please post table and query structure and how you have them related to each other on the Form as well as include name of controls on form and what they are bound what fields in the tables or queries.

This would be a lot easier to try to diagnose if I had the necessary info. Since I don't know the level of expertise with MS Access, I have to assume that the way that you've set up the relationships between the tab control and each of the controls on the respective tab, you're going to run into trouble because your trying to do a 1 to many relationship, but not telling which item (record) go on what tab, and that is why it is displaying your record in any and or all sub tabs that you may select.

If you can post that information, and also any VBA code that you may have written, this would give a better idea of what needs to be changed to make it work the way you want.

Hope that helps,

Joe P.
Jul 25 '08 #2
debson
2
Many thanks Joe.... yes have worked it out, I was trying to autopopulate a PK field... just created an unbound txt field and used this.
Jul 28 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Fork_In_Road | last post by:
I have a main form with customer names & addresses, and a subform that I want to have the following: I wish to pull up an equipment name with a combo box (from my "equipment" table); then have the...
3
by: Eric | last post by:
Hi, I'm just looking into the samples that are delivered withthe Enterprise Localization Framework/Toolkit. I have set it up and it all works fine. But.. now i have a question. I read a...
0
by: guy | last post by:
I am experimenting with the Enterprise Localization Toolkit. Using the Designer and Translator feature, I am able to include a new label in the Basic sample. Apparently, this can also be...
3
by: russr | last post by:
Hi, I need to autopopulate a second field based on the info that i have selected from a drop down box in the first field. I need to write both fields back to a SQL database... EXAMPLE: Field A...
5
by: aharding | last post by:
I would like to autopopulate fields in a form by choosing one value from a table and having the corresponding data filled in based on 'Library' tables I have made. I have been successful in building...
1
by: google | last post by:
I have a form with several subforms. Users enter the data, then on the parent there is a command button that runs code to generate a .pdf document from a report based on the data they are working...
4
by: PRLIT | last post by:
First, let me just say that I've been looking at this site for help for awhile now. Thank you for all the help you given me over the past few months. Second, I'm creating a form in Access 2007. I...
6
by: GLEberts | last post by:
Hi, I would like to ask for some direction on what would be the best way to (1) Autopopulate a combo box to text boxes - used for a customer list (2) Then have the information saved in the...
3
by: hkim8392126 | last post by:
I've been searching and reading the forum, but with no success to find what I was looking for. I am trying to autopopulate a field in a form. I am not sure if I need to create a query or table to do...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.