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

How to use a popup form to filter data on a main form?

P: n/a
-- Access Rookie Question--

Ok here is the situation:

I have a form called frmServices, that has three fields called SvcNo,
SvcName and SvcCity. I created a button that brings a popup form called
frmSearch. In frmSearch I have three unbound fields (SvcNoSrch,
SvcNameSrch, SvcCitySrch) that I want to use to filter data on
frmServices. I've created the command button (btnSearch) and tried many
codes but no one seems to work. Any suggestions?

Juan Ricardo Perez
MIS
Loiza City Hall
Loiza, PR

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
U couls use a dlookup to find all the info related to (your field), or
add the criteria that you want(not sure about this one). Or use the
CTRL-F to have the "normal" MS pop-up window, put the cursor in the
fiels you want to search and hit crtl-f.

Try searching the access ng with search button.

Nov 13 '05 #2

P: n/a
U could use a dlookup to find all the info related to (your field), or
add the criteria that you want(not sure about this one). Or use the
CTRL-F to have the "normal" MS pop-up window, put the cursor in the
fiels you want to search and hit crtl-f.

Try searching the access ng with search button.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.