Updating data in a table from user input on a form

[Guest]

Access 2000
Hi I am trying to make a form where by a combo or list box looks up a Column
in a table then displays this to the user. The user can then edit this info
and it well be saved to the table.

 

[Guest]

Hi Steve

Open you form in design view and insert a combo from the tools menu.
Open the properties box form the combo
Select the name of the field you want to up date from the drop down list
(data column - control source)
In the same column Row Source Type = Table/Query
Row source =
SELECT [TableName].[FieldName], [TableName].[FieldName],
[TableName].[FieldName] FROM [TableName] ORDER BY [FieldName];

I have show to combo for 3 fields (sorted by one). Change this if needed.