[X]My Assistant

[osmith96]

Hey Guys,

So I have a form "Department" and in this form I select a department from the drop down list and press the continue you button which opens up a transaction form.

If I have records already created the form opens up flawlessly. But if I don't have any records created for that department I would like to have a message box that appears and asks
the user if they would want to create the first record for that department and I can't seem to figure this out. I've attached the database so you can look at what I am trying to do. The message box
code is on the on load event of the "Transactions"form.

**Updated the zip file**
This post has been edited by osmith96: Oct 31 2019, 12:24 PM

Attached File(s)

 CoffeeLog_Updated_.zip ( 198.36K )Number of downloads: 6

 

[MadPiet]

Use DCOUNT() to see if records exist for that value (in the combobox). If not, open some form in Add mode, and maybe set the value. Otherwise, open the form directly.

[osmith96]

Can you provide an example?

[tina t]

read up on the DCount() function in Access Help, so you understand how it works. read up on the OpenForm method in ditto. come back if you have specific questions or run into problems.

hth
tina

[PatHartman]

You're making this more complicated than it needs to be. Just have the Transactions form open with the subform showing. The user will see immediately whether or not there are details. If he wants to add one, he can move the cursor to the "new record" line in the subform and just start typing. You don't have to ask him a question. He just does what needs to be done.