How to get data to display in form view when using a parameter que

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a contol button in my form to invoke a parameter query. The
query asks for the parameter, I enter. The crietria is met but the dsiplay of
my data is in table form. I would like the display to be in form mode. I
must be over looking something simple.

Below is the explantaion of what I am doing:

I have created a input data. The user may want to bring up a person's
record for viewing, editing or printing. I have placed a control button in
the form to find the record using a parameter query. The result I get is in
table form, but I would like it as form. I have looked up Help in Access and
online but don't seem to get the answer. Any help will be greatly
appriciated. Thank you.

SC
 
I am using a contol button in my form to invoke a parameter query. The
query asks for the parameter, I enter. The crietria is met but the dsiplay of
my data is in table form. I would like the display to be in form mode. I
must be over looking something simple.

Below is the explantaion of what I am doing:

I have created a input data. The user may want to bring up a person's
record for viewing, editing or printing. I have placed a control button in
the form to find the record using a parameter query. The result I get is in
table form, but I would like it as form. I have looked up Help in Access and
online but don't seem to get the answer. Any help will be greatly
appriciated. Thank you.

SC
Click to expand...

You don't need to open the query AT ALL.

Instead, base a Form *on the Query* and have your button open the
Form, rather than opening the Query.

John W. Vinson[MVP]
 
Thank you. I tried this and it worked. But now I am using two forms, one to
enter data based on the table, and another form to look up and edit based on
the query. I find this a patchup solution , but I am going to use this till
I come across another way.
Thank you
 
Back
Top