Form Opening Help!!!

[Presto731]

I have a paremeter query set up that asks you to enter a value to open it. I want the form attached to that query to ask for the same info when you open it. It does that when you click on the form from the database window. All well and good!

However my problem lies when I try to open the form from a switchboard, it just simply opens the form instead of first asking for the value

I'm sure its a simple answer I'm overlooking. I would certainly appreciate anyone's input and help. Thanks.

[damonreid]

When you are building the button in the form (or switchboard) you need to set open criteria on the open command. Personally I prefer using a combo box to get them to select a value prior to opening the form.

    Dim stDocName As String
    Dim stLinkCriteria As String
 
    stDocName = "NAME OF YOUR FORM"
 
    stLinkCriteria = "[NAME ON NEW FORM YOU WANT TO FILTER]=" & "'" & Me![COMBO BOX VALUE] & "'"
    DoCmd.Close
    DoCmd.OpenForm stDocName, , , stLinkCriteria

[Presto731]

I appreciate the reply. A combo box won't actually work because the number of records is enormous!

My VB skills are lackluster at best. DOn't suppose you have an easier way! :)

Thank you though!

[damonreid]

You can have a blank box and let them type in a value before opening or alternatively on all combo boxes they an start typing in the value and it will autocomplete.

Either way they still have to enter the value, with a combo box it is just a little easier.

[Presto731]

You can have a blank box and let them type in a value before opening or alternatively on all combo boxes they an start typing in the value and it will autocomplete.

Either way they still have to enter the value, with a combo box it is just a little easier.

Sorry. Brain Fart, You're correct. Problem solved. Thanks!