Hello,
I have 3 tables,
tblDailyLog
DailyLogID | LogDate
tblVisitorInfo
VisitorID | VisitorName | CompanyName | TrainingDate
tblVisitorLog
LogID | VisitorName | TimeIn | Time Out
I'm using 2 Forms
[frmDailyLog] from [tblDailyLog] with a continuous subform [frmVisitorLog]
I have entered several names into tblvisitorinfo which uses a lookup field to pull data for reoccuring visitors. is there a way for a user to enter a new name into the log field as they sign in so it is saved for future visits with a unique ID without having to open a new form for a new visitor.
I have 3 tables,
tblDailyLog
DailyLogID | LogDate
tblVisitorInfo
VisitorID | VisitorName | CompanyName | TrainingDate
tblVisitorLog
LogID | VisitorName | TimeIn | Time Out
I'm using 2 Forms
[frmDailyLog] from [tblDailyLog] with a continuous subform [frmVisitorLog]
I have entered several names into tblvisitorinfo which uses a lookup field to pull data for reoccuring visitors. is there a way for a user to enter a new name into the log field as they sign in so it is saved for future visits with a unique ID without having to open a new form for a new visitor.