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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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".
 
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.
 
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
 
Back
Top