have field = value from table

[babs]

I have an append query that is able to append in the customer name - we used
to have the user enter this all manually - now if appended I would like the
customer code to be automatically input if it is null - after the customer
name gets appended in-

control name on the form is txtcustomer code

table name is AR-Customers

thinking I need to use an event procedure-not sure what to event to tie it
to(afterupdate of customer name?)

thinking iif(txtcustomercode is null, ??????? not sure how to reference to
grab customer code value for that customer name in the AR-Customers Table??)



Thanks,
Barb

 

[Jeff Boyce]

Barb

If I'm understand your post, you want to duplicate data that's already
stored in one table into another table. This might be how you'd do it if
you were using a spreadsheet, but it is quite rare to do something like this
in a well-normalized relational database.

If you'll post your table structure and an example of the data, folks here
might be able to offer alternatives.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.