Recent content by KaylaHansa

Yes, it does open the correct form but not to the specific record on that form. It will just go to the first record in the form. @theDBguy I have and after explaining the design they agreed that it was correct.

Each different system is it's own table source, ie AlarmCustomers, CameraCustomers. So each table source would have it's own If line... Which means that access already opens the form to the correct table. It has no problem matching the customer because the customer is selected normally in the...

I have a different dialog form for each system type because it systems has it's own specific fields. So I had a if statement set up so that if it was an alarm system, the alarm system dialog would open. If it's a camera system, then a different dialog would open. I added the table to the union...

I have non-updateable list created from a union query. It is a list of customers and all the different systems they have (alarm, camera, network, ect) It looks like this: Customer 1, System A Customer 1, System B Customer 2, System A Customer 2, System B Customer 2, System C Ect... When you...

I tried the OpenArgs and it worked perfectly! Thank you :giggle:

I'll haven't tried the VBA yet, but I assume it will work the same way?

The problem with that is if the dialog form is set to Data Entry then it will lose the connection and open completely blank, even with the macro. And if it is not set to Data Entry it will keep the connection but will display the first current record instead of adding a new one. (Instead of...

I have a main form which contains a related subform (one to many). I also have another separate form containing fields from the before mentioned subform, designed to be a dialog that is Data Entry only. I have a button on the main form. How do I program it's on click event to open the dialog...

Thanks everyone for the help, I was able to make it work for me! :)

I've already tried that and it doesn't work unfortunately 😒 Disabling it does work but I have an OnClick event added to it, and when it is disabled the click event no longer works.

MajP this works really well, except for the little popup that displays allowing you to add/remove attachments in form view. Is there a way to disable it?

They are stored in the database. I attempted to do an Ilf() expresson in the ControlSource of the image and couldn't get it to work :unsure:

In a continuous form, each record has as yes/no field. Is there a way to have one image displayed in that record if the field = yes, and another if the field=no? I figured out how to do this in a single view form, but cannot figure out how to make this apply at an individual record level in a...

I will try it out as soon as I have the time. Thank you for breaking it down and for all the help, it is much appreciated!!

I'm not sure how to even combine into one table because larger commercial customers may have many sites and therefore several camera systems, each one with it's own modules, site addresses, ect. As for the whole database it's functionality is very simple, just basic data entry/ reporting. I just...