USING DATASHEET TO ENTER DATA

[LMHODNETT]

With all I have read in books and on the internet I assumed that once you laid out the table you wanted to use, you could use the datasheet to enter data. So far that is either a mistake or I do not understand how to do it. I am using a table that is supported by three other tables to make data entries. I can set up a combo box to allow me to choose the data I want in onefield and that is ok. When I try to use a query or combo boxes to fill in several columns in this table from other tables is where I am having the problem. I can select the data from the first column in a combo box. However, the other related fields do not fill in automatically. I know this is probably a simple problem to fix . I do hope someone can give me a simple answer without having to use special coding or programming. Thanks for reading this and any help that you may find time to give.

Larry

 

[ssatech]

I assume you are using the Datasheet method for your form to make the data entry - hence the table for data entry, correct?

One way to do this - use the afterupdate event of your combo box and the DLookup function to fill the other related fields.

Otherwise, take a look at the Orders sample database in Access, specifically the Orders Details Subform.

 

[LMHODNETT]

Thanks for your suggestion. I am going to try this as soon as I have time. I was trying to get the datasheet to work for me, because i had previously used a form for data entry, but had a problem with the data not being stored in the table in all the columns.

Thanks again
Larry