468,321 Members | 1,676 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,321 developers. It's quick & easy.

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

-- 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
2 1421
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
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.

Similar topics

1 post views Thread by Robert Neville | last post: by
7 posts views Thread by Nathan Bloomfield | last post: by
5 posts views Thread by Thelma Roslyn Lubkin | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by howard w | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.