Update Table from Form

[Mark Drayton]

Hi

I'm trying to edit a record within a table based on a selection made from a combo box on a form.

What I'm trying to do.....

In Form 1:
a) From a combo box select a home name
b) Click on a command button to edit details relating to that home within another form, Form 2.

In Form 2:
a) Amend details
b) Close form updates records and back to Form 2

Have been trying to use the DoCmd, ... function but just going around in circles

Many Thanks

Mark

 

[WayneRyan]

Mark,

You don't really need two forms to do this.

Make a regular "bound" Access form.

On that form, add an "unbound" (Control-Source is empty) combo to
select the names.

Make a query that uses the "unbound" combo as criteria in the
appropriate column.

Then use the AfterUpdate event to requery the form.

Use the Search Facility here and look for "search". You'll find plenty
of samples.

Wayne