Subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table called products. In there I am entering all the info about
each product we buy, ie, SN RID MODEL ACCESS# etc. In the Customers form I
created, I have a subform that lists all the fields from the products table.
I want to be able to type in the access# and have the rest of the fields from
that record in the products table populate automatically. Can I do that? If
so, HOW?
 
Simply join the Customer table and the Product table on the ACCESS# field in
a query for your Customer form. I hope you are not using the octothorp "#"
in a field name.

Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update one field from one table to another field in another table. 2
MS Access 2007: Calculated field based on subform: 1
combobox population record dependent 4
link child field with master field using comma as a seperator 3
Access Daily Entry with multiple entries per field 0
Updating tables when you input new data 0
Subform Tabs - Field to Field Auto Populate 1
create a subform without using the wizard 2

Back
Top