By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

Related table question.

P: 25
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.
Feb 14 '08 #1
Share this Question
Share on Google+
3 Replies


cori25
P: 83
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
Feb 15 '08 #2

mshmyob
Expert 100+
P: 903
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.
Feb 17 '08 #3

P: 25
Ive used a different method to access my table data now, but the information provided was of use, thanks
Feb 18 '08 #4

Post your reply

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