How to return a specific record for editing?

  • Thread starter Thread starter p-rat
  • Start date Start date
P

p-rat

I have a switchboard that has a selection Edit Record. Once chosen I
would like a parameter that asks which record number the user wants to
edit. Once typed I would like that specific record to show up in a
previously built form. Then once edited I want the form to close and
the user returned to the switchboard.

I am hung-up big time on this. If anyone has a solution could they be
very basic in description since I am very new to this and pretty much
need to be walked through it step by step. Thanks ahead of time for
your help!!!
 
Use the Where argument of the OpenForm method to open the form to a specific
record. See VBA Help for details

I would suggest an Unbound combo box on your switchboard to allow the user
the select the record. Then when selected, open the form to that record.
 
Just wondering...

Why do you want to do it this way? Why would the user "know" the
record number?

If you create a form that is bound to some data, couldn't the user
simply edit/add/delete from that form? There is a built-in navigation
bar that can be used to type a record number like what you want to
happen from the switchboard.

With that said,

You can create a parameter query that pops up a box asking for the
record number. You then make this query the RecordSource for your
entry form.

Such as:

SELECT * FROM MyTable WHERE RecordNumber = [Please enter the record
number]

Unfortuantely this has no validation capabilities, but its the
quickest to do.
 
dans l'article
(e-mail address removed), p-rat à
(e-mail address removed) a écrit le 21/01/08 16:55 :
 
Back
Top