Subform question

[Guest]

i am very new to access.

i have a form with one text box that pulls the client name from the main
client info form, and one subform that allows me to enter a client's
appointment date, appointment and appointment price.

it seems that the subform is data entry only. i would like it if i could
open the appointment form and not only enter new appointments but also be
able to view the entire history for that client, is this possible and if so
what is the best way to do it.

 

[Gary Miller]

Not only possible, but very normal practice.

Here are a couple of things to check on that could cause
problems...

1) The form that you use for the subform is set to DataEntry
in it's Properties.

2) Your main form is set to DataEntry.

3) Your Master/Child Relationships for the Form/Subform are
not set correctly or are not set.


--
Gary Miller
Sisters, OR



message
news:[email protected]...

 

[Guest]

thanks for your response.

i changed the DataEntry from Yes to NO. i tried to change the Master/Child
relationships but the Child does not have all the same fields as the Master.
Any idea what i did wrong or why this is.

 

[Gary Miller]

You only need one common field between the two to have a
valid Master/Child relationship between the two. All the
rest of the fields should be different. In your case I would
imagine that it should be your ClientID. Would it be correct
that you have a ClientID of some type in both the Client
table and the Appointments table to establish a relationship
between the client and the appointment? The fields can have
different names as long as they hold the common data and are
of a common data type. If not, there is your problem. If so,
then you want to set the Link Master Fields and Link Child
Fields both to that common field in the Data section of the
Subform Control properties.

If Data Entry was set to Yes, that was one problem that you
had. These linking fields also need to be setup correctly
with a common field of some type for the subform to display
existing records for that Client.

HTH

--
Gary Miller
Sisters, OR



message

 

[Guest]

sorry for being a little lame, i figured out why the master and child didn't
have the same fields but i still can't get the history to show up