Adding Data - Form backed by 2 table query ?

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Access 2K -

I have a form which pulls data from two tables e.g. orders and the
customer file. This is done with a simple query matched on a
key/foriegn key.

I need to be able to see the data from the customer table for ID
purposes but I only want to change/add data to the orders table.
Access won't let me add records because the source is a two-table
query (makes sense).

Is there some way that I can do this without using a form/sub-form ?

Thanks,
 
Yes. Base your form only on the orders table. I am assuming there is a
CustID field or something similar. Then on your form, change the text box
linked to CustID to a combo box (lets call it cmbCustID). Set the record
source for the combo box to the Customer table and include every field you
want to show. Back on your form, create unbound text boxes for each field
from the customer table you will be showing. Then for the control source of
each new text box enter

=[cmbCustID].Column(1)

Increment the paranthesis upto the number of fields you have. Move the text
boxes around to have it show the way you want.

Kelvin
 
Back
Top