How to stop append query event messages ?

[viper6277]

Hi everyone, I'm nearly done finishing a database for a legal firm and one of the small issues I'm having with this project is that, I have a button that creates records in other tables once a record is created in a primary table.

I have a table called tbl_login, it has a field called job_number (which is an autonumber), and when all the info is entered in the form associated with tbl_login I want a button to give the user the ability to create a record in tbl_billing with the value of job_number, now this is a easy append query, works great, but the problem is, when the button is pressed there is an event message, "You are about to update an table....." this is the natural warning even message that access gives before a change is made, my questions is.

To please me end users, how do I get that event message to stop popping up. So they just hit the button, it appends, no warning.

I'm open to suggestions,

 

[ColinEssex]

Look up SetWarnings in Access help

Col

 

[neileg]

As Colin says Setwarnings will sort this out.

Alternatively, you could add an invisible control on your form bound to tbl_billing that would create the entry without running an append query.

But why are you creating a blank record in tbl_billing? Surely the time to create the record is when you need to store some data?

 

[viper6277]

As Colin says Setwarnings will sort this out.

Alternatively, you could add an invisible control on your form bound to tbl_billing that would create the entry without running an append query.

But why are you creating a blank record in tbl_billing? Surely the time to create the record is when you need to store some data?

The only field in billing that needs to be filled is job_number, the rest of the fields are user fields. The idea was that, when a job is entered it creates a billing record, billing pulls data from 3 other tables.

I was curious about the invisible control you mentioned, this is new to me. Is that VBA on one of the form controls, such as after update ?

 

[neileg]

I was curious about the invisible control you mentioned, this is new to me. Is that VBA on one of the form controls, such as after update ?

Obviously, if your form is based on a query you can join tbl_billing into the query so that it becomes part of the record source. You can add a control to your form bound to the field in tbl_billing that holds the job number. Then you can set the value of the control to the same value as the control on the form that holds the job number in tbl_login. There's nothing clever about this, you might do a similar thing on any form. However, you don't want your user to be aware of what is going on, so you can make this control invisible in the properties for that control.