Search results

code for no match in subform based query I'm not very experienced but here's what I have to offer. Would it help to use If Me!sfrm_Current_Sales_Book_Description_Count!Count OfISBN_Number.Value <1 Then instead of If Me!sfrm_Current_Sales_Book_Description_Count.nomatch Then Please let me...

smercer, thanks for the reply. Somehow the problem resolved itself. Not sure if it just went away or if I changed something to make it go away.

Johny, the dropdown on the first form is working fine. The problem is the first form's dropdown appears on the second form when the second form opens.

Separate forms.

Help, please! When my second form opens, the combo box dropdown from the first form is visible. How can I make the dropdown disappear?

I have a form with a combo box dropdown. The After Update property of the combo box opens a second form to the record matching the name selected on the first form combo box dropdown. This works fine when selecting the name by pressing Enter but when the user selects the name by mouse clicking...

Andy, forgive me for not replying sooner - - have been out of town for a while. I used the code you provided triggered by a command button and also used it with the combo box as you suggested; meets my needs perfectly. Thanks for all your help.

Thanks for the reply, Andy. All the forms are based on tables which have relationships based on Person ID. Ex: TblPersons contains Persons name, address, phone, etc and has an autonumber field named PersonID. TblAnimals contains Animals name, breed, color, etc. TblPersons has a one-to-many...

When my Main Form opens I want all other forms to open as hidden - - need code. Can be one line for each form or inclusive (if such a thing exists). Also, Main Form has a combo box. When value is selected in this combo box, I want all open forms to find the record corresponding to this...

Thanks, Mile-O-Phile. I thought there was another approach but didn't know what to look for. I looked up "choice" - - an old DOS command. Duh! Thanks for pointing me in the right direction.

I want to make a form containing six to ten command buttons. Each command button will open a different subform. Is it possible to create a public function of nested If to accomplish this? If so, code example of nested If would help a lot. I could then call the function from the On Click of...

Thank you, Wayne. Worked like a charm!

I open a form with the following: DoCmd.OpenForm "frmPersons", , , "[fldPersonID] =" & Me.cmbChooseName, acFormReadOnly The form has an Edit command button - - On Click I want to change from Read Only to edit the data. Can anyone help? It will be greatly appreciated

I apologize. Both your solutions work; problem was my database was corrupt. Applied both your solutions to my backup database and they both work. Thank you very much for the help.

Yes, Mile-O-Phile, I thought that was the answer also. But when the user clicks OK, nothing happens. The whole database freezes; can't close forms, can't switch to design view, can't close the database, can't do anything. Any suggestions, please!

I want to create a combo box NotInList event procedure that displays a message box that requires the user to click OK. After user clicks OK, the focus will be set to another control on the same form.

Thanks, dcs693. Your statement, using Me! instead of Forms!, also works. I appreciate the help.

Dan-Cat, thank you very much for the prompt reply and successful statement.

Please help a newbie! I have a form with a combo box. When the user selects a name from the combo box, I want a new form to open with the record corresponding to the name from the combo box. I know how to do this when the combo box resides on the same form as the corresponding record but need...