Find Record on a form

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

I have a form where the user needs to be able to find a
record based on two field values - MonthID (values 1-12)
and year (i.e 2004). Any idea how I can do this?

Thanks

Cindy
 
Hi Cindy,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

One aproach would be to combine the two values in a column of a query. You
could then base your form on this query (with all the other related fields
that you would need), use the ComboBox Wizard to create a combo box based
on the unique column of the query and it would take you to the record.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Back
Top