access forms subforms

[Demosthenis]

hello everyone,

i believe my question has to do with my poor understanding of access's
functionality and confusion compared to excel...that's why i need the opinion
of an experience user.

I am having a table where i want to enter dates and hours (start-end) for
appointments (Scedule Table) . I have created a form where the user with a
combo retrieves the name of the customer and customer id (customer table) and
other relative info and a subform in order to input the dates and hours. What
I am trying to do is to include automatically the customer id to a subform
field in order each line with a date and hours to have the linking element
with the customer and enter this to the Scedule Table.

Thank you in advance.

D.

 

[Roger Carlson]

The subform control should do this for you automatically. Make sure the
Link Parent Field and Link Child Field properties are set correctly in the
subform control, and that there is a relationship created between these
fields in the Relationship Window.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Demosthenis]

hello everyone,

i believe my question has to do with my poor understanding of access's
functionality and confusion compared to excel...that's why i need the opinion
of an experience user.

I am having a table where i want to enter dates and hours (start-end) for
appointments (Scedule Table) . I have created a form where the user with a
combo retrieves the name of the customer and customer id (customer table) and
other relative info and a subform in order to input the dates and hours. What
I am trying to do is to include automatically the customer id to a subform
field in order each line with a date and hours to have the linking element
with the customer and enter this to the Scedule Table.

Thank you in advance.

D.

 

[Larry Linson]

The subform control should do this for you automatically.
Make sure the Link Parent Field and Link Child Field
properties are set correctly in the subform control, and
that there is a relationship created between these
fields in the Relationship Window.

And, of course, the field that you want to be set should be part of the
Record Source of the Form embedded in the Subform Control (thus, exist in
the underlying table).

And, if you are not using an embedded Form, before you ask, the answer is
"yes, that is what you should have, so just go do it and don't hope that
I'll say... nah, you can use a datasheet view if you want to".

Larry Linson
Microsoft Office Access MVP