Updating data in a table from user input on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top