Search results

try it on the database you have, if you try to put in TBD or something like WD2232 it returns an error in the Project Number field

what's the best way to update Default Value when txtProjectNumber is a text field? Currently if I enter a non-numeric value I will get the error in the field

That's ok, thank you. I look forward to seeing what you come up with.

On the NavigationForm pop up it's the " Finish an Incomplete Request "

NO Problem! I appreciate that you're taking the time!

The first form worked great, but the second tab is still having an issue populating the number (frmIncMultipleRequests). I tried adding the second layer following your concept but still got the Name error...

Hopefully by seeing what I'm trying to do will make it clearer to understand. Thank you for taking the time! You have to click on "Does the Project require Multiple requests" checkbox

It is still giving me #Name? error. :(

The first Subform is FinishReq and frmIncRequestQ is embedded in that one frmIncRequestsQ open the Multiple Requests

What if it's a form within a form that pops up another form? So I have to have the requestors go back and finish a request if they need to. The second button on the Navigation Form has a form with a dropdown so they select the request to finish. This will make an Incomplete Request form...

That worked great! Thank you

I have a Navigation Form in which the first button is defaulted to show a blank form (Request form) where users will enter information. There's an option on this Request form that if there are multiple requests under this request, `a box is checked and another form opens (Multiple Requests)...

So how was the issue resolved with TempVars? I have a similar question

I am basically self-taught and have used MS Access for years, however, my current job requires it more than others. I'm having to use more complicated processes so I may be talking to you all a lot.