How to retrieve a specific record into a form to edit it?

J

J. Rahman

I have designed a form with a few subforms based on multiple table.. what do
i have to do to retrieve a specific record to display in form for editing
purpose? please help!
 
D

Dan Artuso

Hi,
A common thing is to have a combo box where the user can make a selection and the whole
record will then be displayed on the form. The wizard will build one of these for you, just make the
choice to "Find a record on my form based on the value selected in the combo".
 
N

Need More Help

Appreciate it sir!

But I will be needing a little more guidance on this topic from you. The
table has about 10,000 records. Is there a way to make a button on the
swithboard which will ask the user to enter case number and retrieve that
specific record for editing data in the form .. Thanks in Advance.
 
A

Arvin Meyer [MVP]

Probably the easiest was is to base the form on a query. The query should
read something like:

Select * From MyTable Where [Case Number] =
Forms!frmSwitchboard!txtCaseNumber

Substitute your names as appropriate. Have your button simply open the form.
If you've filled in a number, you'll get that record.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top