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

Create Form-Subform to Perform Searches

P: n/a
Hi,

I have created a form containing 5 textfields/combo boxes and a command
button to conduct searches for matching records. My results are
currently displayed as a separate datasheet which is launched by
specifying the query in the OnClick property of the command button.

I would like to create a form that displays the results in a datasheet
on the bottom portion of the same form. I understand that this requires
using the form-subform framework but don't know how to create it. My
efforts in linking the form and subform have resulted in unbound
objects. I would like to trigger subform population on the press of the
command button. Can anyone offer any advice or point me to some place
that has this information?

Thanks in advance.
Brian

Feb 22 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 21 Feb 2006 16:16:15 -0800, gh****@gmail.com wrote:

So you already have a form in datasheet that works.
Bring your Criteria form in design view, and drag-n-drop the Results
form onto it. Voila: a subform. No need to set LinkChild/MasterFields.
Just set the subform's recordsource:
Me.subfrmResults.Form.RecordSource = xxxx

-Tom.

Hi,

I have created a form containing 5 textfields/combo boxes and a command
button to conduct searches for matching records. My results are
currently displayed as a separate datasheet which is launched by
specifying the query in the OnClick property of the command button.

I would like to create a form that displays the results in a datasheet
on the bottom portion of the same form. I understand that this requires
using the form-subform framework but don't know how to create it. My
efforts in linking the form and subform have resulted in unbound
objects. I would like to trigger subform population on the press of the
command button. Can anyone offer any advice or point me to some place
that has this information?

Thanks in advance.
Brian


Feb 22 '06 #2

P: n/a
Thanks Tom. This seems to be woking partially. When I run searches with
the first criteria by itself or the first criteria and another
criteria, the search works. However, when I perform a search using
anything but the first criteria, the search fails. Any idea why? I did
not face this problem with the separate datasheet.

Feb 22 '06 #3

P: n/a
On 22 Feb 2006 05:05:53 -0800, "gh****@gmail.com" <gh****@gmail.com>
wrote:

Not sure what exactly you mean. You may have to show us some real
examples and some code.

-Tom.

Thanks Tom. This seems to be woking partially. When I run searches with
the first criteria by itself or the first criteria and another
criteria, the search works. However, when I perform a search using
anything but the first criteria, the search fails. Any idea why? I did
not face this problem with the separate datasheet.


Feb 22 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.