update a field in one table based on what is selected in another t

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

Guest

I would like to update a main truck table field called( has been assigned)
when in the assigning details the box assigned is checked off. What is the
vb code to update a record in a different table when in the present table -
field is checked yes where truck# are the same????

Thanks,
Barb
 
Do you have a one-to-one relationship between these two tables? If so, you
don't need that filed. You already have a field to indicate this status,
and putting it in another field would be redundant.

If not, how will you do this when more than one record exists for the given
vehicle? If you have two records and only one is checked, then what?
 

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 ID to another table 1
Updating One Field Based On Another 2
subform or hidden fields.....i'm confused??? 4
Not All Fields Update my Table from my Form 5
Continuous form in continuous form 10
Using labels to select records 7
Setting field value if a value exists in another table 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top