By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,240 Members | 791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,240 IT Pros & Developers. It's quick & easy.

Access 97 Bloat with Forms & Queries

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.