Access 2003 design

[Robert smith]

Hi

I have just entered the realms of designing data base design as a hobby.
Having completed a couple for freinds, i how now encountered a problem. I can
also say that i am at a beginners stage in learning about the design. I have
a problem within a form, i have mscal 7, with two subforms, with a command
button/textbox for each subform. I have achieved when selecting a date on the
calender, and pressing the command button the date appears in the text box. i
now want it to change the date in the appropraite subform.

Could anyone help me one this or if there is an easier way to achieve this
please get in touch

 

[Falty]

Hi

I have just entered the realms of designing data base design as a hobby.
Having completed a couple for freinds, i how now encountered a problem. I can
also say that i am at a beginners stage in learning about the design. I have
a problem within a form, i have mscal 7, with two subforms, with a command
button/textbox for each subform. I have achieved when selecting a date on the
calender, and pressing the command button the date appears in the text box. i
now want it to change the date in the appropraite subform.

Could anyone help me one this or if there is an easier way to achieve this
please get in touch

One way you could do would be to use the button to add it to the subform at
the same time, this may not be the best way, but i think it is good to learn
how to use code to enter information from one form to another. This will be
placed int he same place as your code for entering the date on the click of a
button

Forms!NameOfForm!NameOfSubform!NameOfControl = date

NameOfForm = Name of your main form
NameOfSubform = Name of your subform
NameOfControl = Where the date is being put into
Date = reference to the date you want entered

 

[Falty]

Hi

I have just entered the realms of designing data base design as a hobby.
Having completed a couple for freinds, i how now encountered a problem. I can
also say that i am at a beginners stage in learning about the design. I have
a problem within a form, i have mscal 7, with two subforms, with a command
button/textbox for each subform. I have achieved when selecting a date on the
calender, and pressing the command button the date appears in the text box. i
now want it to change the date in the appropraite subform.

Could anyone help me one this or if there is an easier way to achieve this
please get in touch

One way you could do would be to use the button to add it to the subform at
the same time, this may not be the best way, but i think it is good to learn
how to use code to enter information from one form to another. This will be
placed int he same place as your code for entering the date on the click of a
button

Forms!NameOfForm!NameOfSubform!NameOfControl = date

NameOfForm = Name of your main form
NameOfSubform = Name of your subform
NameOfControl = Where the date is being put into
Date = reference to the date you want entered

Hope this helps with your problem

Falty