Access 97 Bloat with Forms & Queries

[Lumpierbritches]

Thank you in advance. Is there a way to programmatically fill an Unbound Form
with a command button, using Queries built?

I have a program that has about 10 different queries that all fill the same
form, same fields etc. So I have 10 queries and 10 forms for each query. I was
wondering to keep bloat down, can you programmatically fill a form with ten
different queries, if all the fields are identical? If so, How?

Michael

[Tom van Stiphout]

On 19 May 2004 12:43:35 GMT, lu*************@aol.com (Lumpierbritches)
wrote:

Yes; programmatically set the Form.RecordSource property.
private sub Button1_Click()
Me.RecordSource = "myfirstquery"
end sub
private sub Button2_Click()
Me.RecordSource = "mysecondquery"
end sub

-Tom.

Thank you in advance. Is there a way to programmatically fill an Unbound Form
with a command button, using Queries built?

I have a program that has about 10 different queries that all fill the same
form, same fields etc. So I have 10 queries and 10 forms for each query. I was
wondering to keep bloat down, can you programmatically fill a form with ten
different queries, if all the fields are identical? If so, How?

Michael