Pull value from one table to another?

[Frank]

I have a database which has a table with rates which change periodically.
What I want to do is pull the rates from the tblRates table into a tblJobs
when I create a new job with the frmJobs.

I know that I can do this with an append query, however some of the
individuals entering the data may not click the OK on the dialog box that
comes up when you run an append query. I would rather make the process
transparent to them.

 

[Rob Oldfield]

docmd.setwarnings false

...just switches the warning off. But do a docmd.setwarnings true
afterwards.

 

[Frank]

I don't understand what you mean by "do a docmd.setwrning true afterwards"

 

[Rob Oldfield]

It's a standard VB command that tell Access not to worry about error
messages.

How you currently running your routine?

 

[Frank]

Jobs are added to the database as they come in. At least one or two jobs are
added daily. Would I add the docmd.setwarning true on a On Save event?

 

[Rob Oldfield]

All that docmd.setwarnings does is to switch on or off the standard Access
warning messages. You're better off leaving them switched on just to catch
anything unexpected, and just switching them off for specific occurences
when you know that you don't want the warning. So the general way of using
them would just be...

'switch warnings off
docmd.setwarnings false
'run an append query
docmd.runsql sql (or docmd.openquery "whatever")
'switch warnings back on
docmd.setwarnings true