Macros to Create Search Form

M

MadCSS

I am trying to find a way to use combo boxes and macros to run a search using
a form...anyone have any ideas? Essentially, I want the user to be prompted
to select a date from the combo box, which, when selected, will lead them
directly to that field that they searched for. I don´t have much experience,
but I feel like I am right on top of a solution, but can´t find a way to get
there!
 
J

Jeff Boyce

I'm not clear on a couple of your points ...

How does selecting a date "lead ... to that field"? Wouldn't they need to
first select the field to search, then search for the date value in the
field?

Maybe I'm assuming that your table structure is well normalized ... are you
(not) saying that the field name includes a date value?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to clear prior search terms from Navigation Pane 0
Dynamic Naming of Form Button 3
Automatic Emails sent to my Contact Groups by Microsoft 1
Create a chart from a table in word thats dynamic 0
VBA word change keys 0
How do I set focus (and select text) on a text box on a modeless userform? 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0

Top