Populating a form with table data!

[Extracash]

Folks,



I am sure that this is simple for most of you, but I have not figured it out yet!

I have an activity table that I want to add new records to using a simple form. The activity table has a relationship with a customer master table via the customer number.

I would like to be able to use a combo box or some other technique to select the customer number and have Access pull data from the customer master table to populate the activity record. This allows me to use default data from the customer master record rather than to rekey the entries if there are no changes.

How can I do this?

[RuralGuy]

All you need is a query that joins the two tables on the customer number field. You can then access any field in either table through the query.

[Extracash]

RuralGuy,

I will give that a try this evening and let you know the results. Thanks!

[Extracash]

RuralGuy,

In the form, I have an unbound combo box that allows me to scroll to the desired customer number. In the query for that same form, I tried to pass the combo box entry to the customer number for the master record to allow me to pull in the data. It does not work.

Am I able to do all of this within the one form? I presume that I can.

Thoughts?

[RuralGuy]

You should be able to set the Query as the RecordSource of the form instead of the table and your ComboBox should work. If the cbo does not work then use the wizard to create another cbo, selecting option #3.

[Extracash]

Thank you! I am good to go!

[RuralGuy]

That's great! Are you ready to follow the link in my sig and mark this thread as Solved?