Best way to do things

[alexfwalker81]

Hi,

I'm struggling to settle on the best way of doing things in this scenario and could use some help.

I am building a simple electronic sign in system for Reception. The user completes a form (Form A), providing their name, car reg etc and also indicating which warehouses they'll be visiting. A badge number is allocated, using an autonumber. I'm using a report to print using a Dymo Labelwriter.

In most cases the form will close, and that's the end of the procedure. However, if some of the warehouses are selected, then the user needs to complete another form (Form B), for medical screening.

What I am struggling with is;

- How I close Form A, and open Form B if some checkboxes are ticked?
- How I pass the Badge Number from Form A to Form B, so that I can tie the two together later in queries.

Very happy to share the database itself (there's virtually no data in it) if anyone wants to look further.

Alex

 

[isladogs]

Use If...Else..End if to close form A and open form B if chk1= true etc
Or just close form A if not.

In form A, save the badge number as a variable e.g lngBadgeNo
Open form B and reference that variable

 

[Mark_]

For myself, I would be tempted to do this as two tabs on the same form. IIRC, you can hide the second tab without issues. In the data that drives selecting where they will go you can check if any of them need the medical screening. If yes, unhide the second tab.

Colin's advise works if you really do need two different forms though. If this is all drive by one table though, two tabs on the same form may be much easier.

 

[isladogs]

I agree. Mark's idea is better.
And just to confirm, you can show or hide tabs using code

 

[alexfwalker81]

Thank you both.

Just in case you hadn't already anticipated my next question... What's the code to show/hide tabs on a form? Or perhaps better still, can you point me in the direction of any resources that will show me how?

Thanks,

Alex

 

[isladogs]

Hi Alex

Yes I was expecting that....
See attached example - the second page (Additional Info) is only visible once visitors are assigned a badge number

HTH