autofill fields

[sharon attwood]

I originally wanted to populate the table used for the form being viewed with information based on another table, which has a common field, but having read other threads this does not seem possible.

I tried to create the query suggested so the fields could be linked and therefore the control set to the new name, however when I do this it does not allow any new records to be added.

Can you let me know what I am doing wrong

Thanks

 

[dcx693]

I originally wanted to populate the table used for the form being viewed with information based on another table, which has a common field, but having read other threads this does not seem possible.

This all depends on what you want to do. Can you explain?

I tried to create the query suggested so the fields could be linked and therefore the control set to the new name, however when I do this it does not allow any new records to be added.

The ability to update a query depends on a few things. There's a good section in the Access on line help about this. Try searching the help for "When can I update data from a query?"

 

[sharon attwood]

I have a table of product codes & descriptions

I have a separate table of all repairs to any products and a separate table of our spares inventory.

The last two tables populate various forms and I thought it would be easier to produce these forms based on complete information from one table as I cannot seem to get them to work any other way.

I tried to create an expression in the default value of the description in the repairs form which would look up the description from the product table based on the product code and populate the repairs table behind the repairs form.

I'll check out your other suggestion about adding data to queries.

Thanks for your help