Newbie Tab Form Problem

[AndyD]

Have a small problem (and probably very simple!) with a database im putting together, hopefully someone can help.

I have a main form and "tabbed" form.

When I change the record on the main form the data (6 yes/no fields from the same table) on tabbed form does not change to reflect the particular record selected, it just shows the first records data


I've tried a few things, but no luck. I'm sure there is a simple solution.

Thanks

A

 

[ajetrumpet]

When I change the record on the main form the data (6 yes/no fields from the same table) on tabbed form does not change to reflect the particular record selected, it just shows the first records data

Sounds like you are missing a master/child link between the two sections of data. Are you operating in a Main Form / Subform context?

 

[boblarson]

If you are using a subform (for all data in the same table) you really shouldn't. All you need is to assign the table to the form's record source property and put the fields on the tabs as you want them. Make sure that the controls are bound to the table fields and then when you navigate the form the data will change because you are all on one record. There is no need for a subform due to using the same table.