query by means of a form to be filled in

[pschrader]

Hi !

I'm using MS Access 2002/2003.

I have a table A with fields F1, ..., FN, and additional fields.
I want to show in a result form all rows of A with given values v1, ..., vN
for the fields F1, ..., FN.
But I want the values to be entered in controls in another entry form.
The controls are of the types that are produced automatically by the MS
Access forms assistent for a query of A.

What solution do you suggest ?
Thank you very much.

Peter

 

[John W. Vinson]

Hi !

I'm using MS Access 2002/2003.

I have a table A with fields F1, ..., FN, and additional fields.
I want to show in a result form all rows of A with given values v1, ..., vN
for the fields F1, ..., FN.
But I want the values to be entered in controls in another entry form.
The controls are of the types that are produced automatically by the MS
Access forms assistent for a query of A.

What solution do you suggest ?
Thank you very much.

I don't guess I understand the question.

A Form is just a window; you can set two different forms' Recordsources to
your table, or to a query based on your table. You can enter data in one form
and display it in another. You can use a Single form to display just one
record, or a Continuous form to display multiple records in rows, or even a
Datasheet form if you wish.

What specifically are you trying to change? What do you want the form to look
like?

John W. Vinson [MVP]

 

[pschrader]

I'd like to use my own entry form for specifying the criteria for the
records to be selected from table A.

For example, the field F1 in table A might be a yes/no field, the field F2
might be a number field,
and I want to select records from A according to their values of F1 and F2.

Therefore, my entry form will have a checkbox for specifying the value of
field F1,
and it'll have a text box for specifying a numeric value for F2.
I'd like to set the checkbox and the textbox to the values of F1 and F2,
and then push a button
to have another form show up which displays the selected records,
where F1 and F2 have the values I specified in my entry form.

How can I do this in Access ?

Thank you very much for your kind help.

Peter