Updating combo box in a Access table

  • Thread starter Thread starter greenbg
  • Start date Start date
G

greenbg

I would like to know how to update severval fields in table at one time with
a query module...

Thks
 
Create e query and then make it an "Update query" by selcting this from the
querymenu bar. In the field "update" place your fields that need updating
between brackets. If you have several tables you should join them and place
the tablename in front of them. So it could look something like this:

update: [table1].[yourfield]

where table1 should be replaced with your tablename and yourfield should be
replaced with the field you want it to update to.

hth
 
thanks it working great...
Create e query and then make it an "Update query" by selcting this from the
querymenu bar. In the field "update" place your fields that need updating
between brackets. If you have several tables you should join them and place
the tablename in front of them. So it could look something like this:

update: [table1].[yourfield]

where table1 should be replaced with your tablename and yourfield should be
replaced with the field you want it to update to.

hth
I would like to know how to update severval fields in table at one time with
a query module...

Thks
Click to expand...
Click to expand...
 
Back
Top