ahmed_optom
Registered User.
- Local time
- Today, 05:51
- Joined
- Oct 27, 2016
- Messages
- 93
I am making a very simple diary.
I have made a table, it has ID, Patient ID, AppointmentDate and SlotNumber.
all im trying to do is have a text box that will fill with patient ID if the slotnumber and date is checked.
This is what im using now :
=DLookUp("[Patient ID]","[Diary]","[AppointmentDate]=#" & [Text13] & "# and [SlotNumber]=1")
For some reason it works only about 10% of the time. the rest of the time its just returns a blank, no error.
What I have noticed it works for the first use of the form, but if add another entry to the table for a different date, then it doesnt return anything. It only seems to work with one entry into the table. Obviously not useful
The way the form is organised, means there will only ever be one appointment for each day in each slot.
Any ideas?
I have made a table, it has ID, Patient ID, AppointmentDate and SlotNumber.
all im trying to do is have a text box that will fill with patient ID if the slotnumber and date is checked.
This is what im using now :
=DLookUp("[Patient ID]","[Diary]","[AppointmentDate]=#" & [Text13] & "# and [SlotNumber]=1")
For some reason it works only about 10% of the time. the rest of the time its just returns a blank, no error.
What I have noticed it works for the first use of the form, but if add another entry to the table for a different date, then it doesnt return anything. It only seems to work with one entry into the table. Obviously not useful
The way the form is organised, means there will only ever be one appointment for each day in each slot.
Any ideas?