linkin forms and subforms

[lendinas]

Hello.

I am new to Access programming so I have som, perhaps, elementary questions.
My db has only to table that are related by a one-to many relationship.
Everything works fine with the relationship.
I have some questions regarding to some form designs.

The main table is the form. I need to know how can i create a shortcut of the used forms, in order to show the user only the forms not the database behind.

Second, everytime I open the main form I need to point out for a new record.

Third, I have a check box in the main form. I want that when I click the checkbox to yes, to promt me a subform that will be fulfilled with information taken from the second (child table).

Thank you in advance for your time

 

[Fizzio]

Hi, and welcome to the forum.

All of your questions have been answered here befor so I suggest you use the search facility to get your answers, try these search terms for starters

hide database window
startup options
new record form
show subform

Have a browse around, you will find a lot of answers and I'm sure one will fit the bill. If you are still stuck, then reply.

 

[lendinas]

thanks

Hello thank you for your reply.

It was helpful to search the help and I got used with many features. But I need some help in programming. I understand the basic features but I want to do the following (I have limited time)

can you please provide me an example procedure that controls my checkbox in the main form. So that when I check the checkbox, a subform (child form) is displayed, and when I do not check that box, the subform is hidden.

Moreover can you send me an example procedure that by setting a string variable for a field in the main form takes the input. Simultaneously by taking the user input controls the source table if this value exist and if no adds this as a new record.

thnx