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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text Field is Now Combo Box 2
Access Control on subform / combo box requesting parameter 0
Access Replication Syncronization list 1
latest updates hoses system 12
Combo Box in Table 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Adding a Combo Box 2
Building cascading lookups in an Access 2007 table 1

Back
Top