list box help

wayne,

i have been working on it but dont think its efficient let me know what u think
 

Attachments

wayne,

this is how it works

1. guest comes to gate gives either resident name or address(lets work on name )

2. guard clicks button on a form or switchboard to enter a partial last name

3. guard chooses from a list of residents hits enter

4. guest list from that loc# (linked from location table) comes up, guard selects guest and hits enter. if guest expire date is expired
a. go to contact form if ok to let in (yes) button to open guest record from guest table and edit dates.
a1. after edit go to frmGlogEnter to enter guest lic.plate and any notes to go into gatelog table

b. if not on guest list go to contact form if ok to let in (yes) button open guest form to enter new guest.
b1. after enter go to frmGlogEnter to enter guest lic.plate and any notes to go into gatelog table


note: guest with no date in the expire field are permanent guests
 
the way this is all setup creates a lot of forms. can i use a module or something to do the same thing with the same form.
 
I have a ? for all. i posted a sample database. i seem to have to use alot of forms to accomplish what i wanted. need to find a solution that utilzes the same forms if possible.

thanks in advance
 

Users who are viewing this thread

Back
Top Bottom