Hi Everybody
I am doing some work in access. I need help to ease the job by some automation through "DlookUp" or "ELookUp"
My task is very simple
I have a form of passengers based on Passenger table which has different fields including FormNo
Table two (ApplicationForms) contains only One field "Forms" (04501 to 04600)
What I want when I click a button the DlookUp bring the minimum formno from ApplicationForms like 04501 to Filed FormNo.
And if already used in the underlying table then give message and alot the avl minimum number.
thanks if somebody helps
I am doing some work in access. I need help to ease the job by some automation through "DlookUp" or "ELookUp"
My task is very simple
I have a form of passengers based on Passenger table which has different fields including FormNo
Table two (ApplicationForms) contains only One field "Forms" (04501 to 04600)
What I want when I click a button the DlookUp bring the minimum formno from ApplicationForms like 04501 to Filed FormNo.
And if already used in the underlying table then give message and alot the avl minimum number.
thanks if somebody helps
