PDA

View Full Version : Access checkboxes and VBE codes



erikgutten
02-21-2014, 03:29 PM
Good day to you all fellow nerds and wizards.


I'm sitting here with some questions for my forms and tables in my new database that i am working on.


The qustion is simple for you who know them, but in my effort to avoid opening my access2007 bible, i thought asking here would be faster.


My attemt is for my condomonium to create a deasent working DB to hold all my necessary data in different tables and so forth.
on my main form i got these checkboxes:
AppartmentSublet shall open SubletFrm
ParkingLot shall open parkingFrm
Garage shall open garageFrm
FuseboxUpgrade copy owners contact details into new table (here i can use reports)
DoorChange shall copy contact details into new table (here i can use reports)

Each of these when clicked shall then do a copy or later on do this copy to respective tables.

I guess i could add command buttons onthe form to run a check if any of thes are ticked off, and then to call the table form to enter data that would not be visible in the initial form. Just to make it a bit more user friendly.

There might even be an easier way to do it even, but didn't use time to check it out.

I Could even use webmatrix, but not gon there yet for any coding needs.


Thank you all for any pointers, help and other clues