Recent content by Staelens30

I am trying to make a new form but cannot think of how to set it up to bring in the other tables so that everything will enter into the right tables I still have not made command buttons to open the other forms yet this is a work in progress that is taking me a very long time to accomplish i...

i have multiple tables all linked together that i would use to build a entire record but the form is kicking me.

would be it be a good itdea to make a main form for the main table then add command buttons to open other forms to input to the coresponding tables or a form with mulitple subforms I would like the forms to look as professional as possible.

I hope this is what you are refering to when you say noramlize the tables.

can you use mulitple forms to add to one table and then use another form to add new data to a record

I have tried alot of different code and i am still not able to get what i am trying to accomplish i am posting a copy of db. I would like the fields below first name 2 and last name 2 to move up when the tow buyers checkbox is left blank.

here is the database that i am refering to

I would have to send you my file for you to see what i am refering to i would like to have my form in my database expand when i click on a check box so that it is all compressed when the fields are hidden. if that makes any since

i am looking for the best person out there for a little help and suggestions on a database that i am trying to build

ok i have finally figured out how to get hidden fields on a form to show and hide based on a checkbox selection my next question is how do you get the rest of the fields to move up to the blank space and move down when the hidden fields are shown.

i would like to use a combobox to select the table that the data is to be inserted. for example if the user selects new in the combobox then the data is inputed in the table for new and the same would be for used.

that worked perfectly. Now i have another problem how do i get the fields below to move when the others are not in use. by this i mean if i have them hidden and are not being used there is a gap where they are going to show but i would like the form to gap free and expand when the appropriate...

ok i have tried a few different ways and keep getting an error. If I want to click a check named Two Buyers I would like the labels and text boxes to come up to input the second buyers information.

could you give me an example of the if formula i would type to make the hidden fields to show or the shown fields to hide or would it be VBA coding

do i have to create additional forms or can all of this be on the same form