Update Records on Input Form

[forrest33]

I have an input form that contains a Company Name field. The source of this field is a lookup column in another table.
The input form receives info in regards to each Company Name. However, when I choose a certain company, I do not get the related info displayed on the form, although the backend table has stored the input.
Thanks.

 

[jordanking]

is this form bound to the table or what is its record source?
Need more info. Are you using a combo box for the company name? Does it have an ID?

.....
I'd rather be surfing

 

[forrest33]

the record source for Company Name is a combo box in another table, where it does have an ID.

 

[jordanking]

okay, is your form bound to a table? What is the form's recordsource?

Are you looking to "pull" info from the company table into the current form controls. You will need to add code to the change, update, or lost focus event of the combo box.

What have you tired?

.....
I'd rather be surfing

 

[forrest33]

the form is based on a Business Expansion table, where one of the column is Company Name, linked to Company Name in a Manufacurer table. The Company Name combo box has as a record source the Company Name in the Manuf.table. Is this correct? I was trying to build a macro around the on update event, but could not find a corresponding command.
Thanks.

 

[jordanking]

that helps, but what are you trying to do? do you want to take info from the manufacturer table and fill into fields on the current form? If so, don't use macros. It would be better to use VBA code(I never use macros). You can then easily use the update event to query data from the manufacture table and fill in the forms you need.

IF you give me a detailed description of what you are trying to do, i can give you some examples.

.....
I'd rather be surfing

 

[PHV]

Have a look here:

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins

http://r937.com/relational.html

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886