Enforcing a selection to open a second form

[CT_AccessHelp]

Ok you all have been sooooo helpful! Hopefully this is the last thing I need to deal with on this database.



I have a the two forms below, the first one opens the second one and limits the records that can be seen by the selection of the county and practice on the first form. The problem I am having is the user can skip selecting the County and Practice and open the second form for entry, I need to stop them and force a selection. Any Ideas? I included the code for the Add or Edit Offer Button, it is tied to the on click option. Thank you!

[orange]

My first comment is in regard to your naming convention. If you have to maintain this, or -especially if anyone but you has to maintain this- using names that describe the purpose of Comboboxes and buttons is extremely helpful.

How would you rate
Command3 with something like btnAddEditDataForCCRP

You can check for the presence of a value in cboCounty and cboPractice before offering to Open second form.

Along the lines, or similar functionality

(untested air code for concept only)
If Nz(me.cboCounty,"") ="" then
msgBox --you must select a County
end if
If Nz(me.cboPractice,"") ="" then
msgBox --you must select a Practice
end if


--only after selections have been made does the logic flow to open the second form.

[CT_AccessHelp]

My first comment is in regard to your naming convention. If you have to maintain this, or -especially if anyone but you has to maintain this- using names that describe the purpose of Comboboxes and buttons is extremely helpful.

How would you rate
Command3 with something like btnAddEditDataForCCRP

You can check for the presence of a value in cboCounty and cboPractice before offering to Open second form.

Along the lines, or similar functionality

(untested air code for concept only)
If Nz(me.cboCounty,"") ="" then
msgBox --you must select a County
end if
If Nz(me.cboPractice,"") ="" then
msgBox --you must select a Practice
end if


--only after selections have been made does the logic flow to open the second form.

I know things should be named better, I pick the database up form someone.

Soooo were would I put this code?

Thanks

[orange]

Who built the forms?
Do you understand Events?

Quick overview:

You present a form to the user (Form1).
On that form are Controls (combobox, button, .....)
For each control, there are events -- things like load, open, before update, after update etc.(Different controls support different events)
In the combo, let's pick cboCounty, if the user makes a selection, this triggers the afterUpdate event
For the form generally, there are also events. One of which is BeforeUpdate. This is the last chance you have to interact with the form and data before it is updated. So, in the BeforeUpdate event you can check to see if each combo has a value (You're looking for a value that is NOT Null and not a zero length string.)
If either or both are not valued, you send a message to the user and bypass opening the second form.
Only if both combos have valid values do you open the second form.

[ssanfu]

This sounds like a search form.
You provided a pic of the button code, so you might try putting the code orange suggested between the last DIM statement and the "stDocName statements.

[CT_AccessHelp]

This sounds like a search form.
You provided a pic of the button code, so you might try putting the code orange suggested between the last DIM statement and the "stDocName statements.

Thanks for the suggestion but it didn't work.

[orange]

Please provide a copy of the database in zip format.

[CT_AccessHelp]

[QUOTE=orange;314001]Please provide a copy of the database in zip format.[/QU

[CT_AccessHelp]

CRPAllocations_03152016.zip Hopefully this works

[orange]

I'm looking at your database Form.

Have added code to require a selection in combo1 and combo22.
I'm not sure what the other 2 buttons are intended to do as far as the comboboxes are concerned.

------>Look at the click event of command3.<----------

I have modified the database -- event code for click event of Command3.
Data base has the same name. Zip has the same name.

[CT_AccessHelp]

I'm looking at your database Form.

Have added code to require a selection in combo1 and combo22.
I'm not sure what the other 2 buttons are intended to do as far as the comboboxes are concerned.

------>Look at the click event of command3.<----------

I have modified the database -- event code for click event of Command3.
Data base has the same name. Zip has the same name.

This is perfect!!! You are my hero!! Thank you sooooo much!

[orange]

You are welcome. Happy to help. But this is just to prevent opening the second form.
There may be other "issues" with your intended work flow, if users can bypass/skip steps.
Better to make sure the user has followed your designed process --check the logic of your code etc.

Good luck.