Command Button>Form Operation> Open Form...also need find function

[Guest]

Hello,

I am looking for a way to find existing data in the form/table. Here's what
I am looking for:
1. click on a button
2. Button launches a field "Ticket #"
3. user enter the tickket #
4. system returns entry related to the ticket #

I belive I can achieve this by adding the command button and under the Form
operation I can pick Open Form. This gives me two options. 1. Open the form
and find specific data to display. 2. Open the form and show all the records.
When I pick #1 I get an error saying that "You have chosen forms that can't
be linked. You must have atleast one field that can be linked to each form."

Can someone please help me with above issue? I need a way to build in Find
functionlity.

Thanks!!

 

[Larry Linson]

I am looking for a way to find existing data in the
form/table. Here's what I am looking for:
1. click on a button
2. Button launches a field "Ticket #"
3. user enter the tickket #
4. system returns entry related to the ticket #

I belive I can achieve this by adding the command
button and under the Form operation I can pick Open
Form. This gives me two options. 1. Open the form
and find specific data to display. 2. Open the form
and show all the records. When I pick #1 I get an error
saying that "You have chosen forms that can't be linked.
You must have at least one field that can be linked
to each form."

I'd wager it is telling you the exact truth... that you had not added the
Unbound Control to the Form into which the User would enter the Ticket #.
Perhaps your expectations of the Wizard were too high.

(BTW: A Command Button can Open a Form... it doesn't "Launch a Field.")

_Had_ you placed the Unbound Control into which the User would enter Ticket
# on the Form prior to using the Wizard to construct the Command Button?
That is what was needed. You should, of course, alter the code generated by
the Wizard to check that the user has entered something into the Ticket #
Control before you use it as though they had.

{{I would not, but if you feel compelled to add extra steps, you can add the
Control, set its Visible property to No, then add a Buttion which when
Clicked sets the Visible Property to Yes, and then (perhaps after the user
has typed a Ticket Number into the Control), Enable the Command Button that
will Open the Form.

Larry Linson
Microsoft Access MVP