Required info

[BB]

I have a combo box (LastName) on a subform (driver infomation). (The main form is the vehicle rental request.) The user picks a last name (or types it in). The SSN is what is stored.
How do I make it required that the user must enter at least one driver? What am I missing?

Thanks, (new to Access) BB

 

[jwindon]

Set the field to "Required" in the table.

 

[BB]

Well, I don't think that is quite it. I must be missing something and/or I didn't explain completely. I want to require that at least one record is added to the subform. A request for a vehicle must include at least one driver. (This info is going into my intersection table. A request may have many drivers; a driver may be on many requests.) I'm not sure how to handle it?
Thanks

 

[jwindon]

Yes, apparently we are not on the same page.

First you have a table of VEHICLES.
Second you have a table of DRIVERS.

Rather than trying to use these two tables together to create your RENTAL, you should have a third table RENTALS.

tblRentals
VehicleID
DriverID

Base your form off the table, making the DriverID required.