Access Form Update and or Add New

[jcrone]

I can't figure this out. I can do one or the other but not both. I want my form to open, put in a work order if it exists it will auto populate my form fields, if not it will add a new work order. Seem like this should be pretty easy

 

[welshgasman]

I would probably try something like this?

In the AfterUpdate event of your control that will hold the work order, see if it exists using the value, perhaps a findfirst on the workorder.? If it does not exist then [FONT=&quot]DoCmd.GoToRecord , , acNewRec[/FONT]

HTH

 

[xenou]

I can't figure this out. I can do one or the other but not both. I want my form to open, put in a work order if it exists it will auto populate my form fields, if not it will add a new work order. Seem like this should be pretty easy

You would need some kind of input in order for Access to know what work order you want put in. Generally, you would have a form like this open "ready" for entry, but (possibly) with a search button so you can search for existing work orders too.

 

[jcrone]

Thanks, I will give it a shot