Related table question.

[Codebug]

I have a form and would like to know the best method to link it to a related table so I can retrieve data from it to the form, and maintain this link if the Forms current record is changed.

I have put a subform on the form linked to a Query file, then set the Visible property to false. But there must be a better method to use.

I want to be able to parse the data from this table using the main Forms OnCurrent Event.

[cori25]

Hello...

In order to have a combo box pull directly from a table/query....this is how it is done...

1.) When creating the combo box, in properties got to Row Source Type, select Table/Query

2.) Then in the Row Souce(which is directly beneath Row Source Type), select either the table/query you would like to get the data from.

Thats it!

Let me know if this works

[mshmyob]

Assuming you meant that you want to bind a table to a form. You would just bind the controls on your form to an underlying table.

Set your Record Source property to your underlying table and then set the Control Source properties for ech control to a field in that table.

Now when you add/edit or move between records everything will be updated automatically.

I have a form and would like to know the best method to link it to a related table so I can retrieve data from it to the form, and maintain this link if the Forms current record is changed.

I have put a subform on the form linked to a Query file, then set the Visible property to false. But there must be a better method to use.

I want to be able to parse the data from this table using the main Forms OnCurrent Event.

[Codebug]

Ive used a different method to access my table data now, but the information provided was of use, thanks