Setting field value if a value exists in another table

R

RussCRM

I work for a shelter and occasionally we have to ask a guest to leave
for some reason. We call this being "barred" from our services. When
a staff person opens the main data entry form, based on "tblGuest",
there is a subform on a tab where this information can be entered. If
a guest is barred, a record is placed using the subform in
"tblBarInformation". The fields in this table are "BarID",
"BarLink" (equal to GuestID from tblGuest), "BarDate", and
"BarExpires."

Basically, I want to create a field in tblGuest that indicates the
guest's status as Barred if there is a current bar record in
tblBarInformation. So far, I've created a query such as this:

BarLink BarCurrent: [BarExpires]
Group By




I am working on a subform that contains data
 

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

Setting field value if a value exists in another table 0
Setting field value if a value exists in another table 3
Do I need a sequential primary key? 7
Setting column width in a table with a macro is not working 0
Prevent Subform from saving record or delete record when moving tomain form 1
Counting consecutive dates 5
Adding Records with a Query? 7
Trouble getting date value from field 3

Top