Open form based on query information

[MFS]

Hello all,
Okay, lets see if I can explain this with as little confusion as possible . . .
I wrote a query that is asking for you to enter the ID number of the table information you wish to review. So when the query starts It will ask "Enter ID Number" I would then like the database to goto that form that was designed showing all the information related to the ID number entered.


(Open Work Orders form)

If the task has already been completed, based on a check box related to the ID number, being false then I would like a form that opens and says "The task has already been completed, would you still like to review or return to main form?" With a "Yes" or "Return to main" command button.

Can someone help?

Mike

[June7]

Will try to answer with as little confusion as possible.

Is the query with the prompt also the RecordSource for the form? This would be the only way to 'pass' the criteria to the form, the form has that query as its recordsource. Open the form, the prompt will popup, and the entered criteria is part of the form's RecordSource.

Then second question of your post requires code to accomplish.

[MFS]

"Is the query with the prompt also the RecordSource for the form?"

Yes it is, and I could get it to work but was looking for something that would tell the user that . . . "Work Order Number ?? has already been closed, would you still like to open form and review data ?" "Yes" "No"

[June7]

Then you need to write code. I use only VBA, don't know if macros can do this.

User enters criteria into textbox on form. Code checks for status, if closed issues a MsgBox prompt. Response to the MsgBox is processed by code. Otherwise, just open the form to the requested record and let user face possibility it is closed. You could have a textbox on the form that indicates the status and with conditional formatting it could be displayed with alternate color if closed.

I don't use query parameter prompts. Too hard to validate input and can't reference the response in code.