Load form based on a value in a table

[mrathi]

Hi, I have a navigation of forms. For example, my main form is Form1. I can go to form2 from Form1 and to Form3 from Form2. Now, if I change something on Form3, a button is made visible on Form1. So, far I can do this. However my problem is:

When I close the application and open it again, the button is not visible on Form1. I have to go through the process of opening Form3 and then the button becomes visible on Form1. I want to put something in the on load event for Form1, but since Form3 is not open during this time, it gives me error? How can I do this? Please help.

Thanks

 

[KenReay]

Hi

Is the data you input on form3 which causes the buttons visible status to change saved anywhere (eg in a table)
if yes, where ?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[mrathi]

The data is stored in a table

 

[mrathi]

The table has several fields. Based on one of the field's value, the buttons should be visible or not. Thanks

 

[KenReay]

Hi

OK, so either make that table the recordsource of Form1, or include it in the query which is the recordsource of form1

If neither pf these two are possible, then open the table as a recordset in the forms form open event and depending on the value of the column, set the button visible, not visible as appropriate



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK