I have a form which derives its content from two tables
using a join query. I want to include name & address info
from a third table (user) which has only one record. I want
to be able to overwrite/change this info on the form if
appropriate to the situation.
Question: How do I retrieve this data and get it on the form
when it opens? Ideally, if the name & address fields are
empty then I want this info retrieved from the third table. If
these fields are populated and/or changed I want the info
to remain that way.
I imagine the solution is not too complex but I'm relatively
new to VBA and procedures etc. Any guidance will be much
appreciated. Thanks & regards:banghead:
using a join query. I want to include name & address info
from a third table (user) which has only one record. I want
to be able to overwrite/change this info on the form if
appropriate to the situation.
Question: How do I retrieve this data and get it on the form
when it opens? Ideally, if the name & address fields are
empty then I want this info retrieved from the third table. If
these fields are populated and/or changed I want the info
to remain that way.
I imagine the solution is not too complex but I'm relatively
new to VBA and procedures etc. Any guidance will be much
appreciated. Thanks & regards:banghead: