How to return a specific record for editing?

[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!!!

 

[Klatuu]

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.

 

[n00b]

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 :