Update form?

[Guest]

I want to be able to edit a table. I want to be able to select a specific
record and then update certain field(s). I can get a table view on a record
by using a query, but I'd like to get a form (similar to my data entry form.
I can do it this way, but I have to scroll through all the records to get the
one I want.). It would be nice to have the option of using a drop down box to
select a record or enter it directly. What aproach do i take to do this?

Thanks.

Phil

 

[SusanV]

You could use Access's built in Find button, or code one yourself, something
like:

Private Sub btnGoTo_Click()

Dim cust As String

cust = InputBox("Select the Customer You Would Like to View", "Select
Customer")
DoCmd.OpenForm "YourFormName", acNormal, , "YourCustomerField = '" &
cust & "'"

End Sub

 

[Albert D. Kallal]

On you form in design mode, drop into the form a combo box using the wizard.

choose the option to "to find a record....".

The above will build you a drop down list that list you select a name..and
the form then jumps to that record....

 

[Guest]

Thanks Albert, it did what I was looking for.