newby trying to create form based on a query and then append data to table - formview1.gif (0/1)

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

I am working with Access 2000. I have a table with protocol names, a
table with subject names, and an observation table. I have 6
protocols and each one uses different names from the names table. I
created 6 queries (one for each protocol) that shows only the names
associated with them.

What I want to be able to do is have a form that lists the 6
protocols. When you choose a protocol, a sub form pops ups with all
the names belonging to that protocol so that all you have to do is
enter the date, time, and initials of the observer(s). The rest of
the fields (6 more dealing with behavior) all default to 0 (meaning
normal) and you would then just change that number (from a list
0,1,2,3,4,5) if needed.

I thought at first that this should be simple, but I have put in over
40 hours and still have nothing usable.

I have attached a gif that shows sort of what I am trying to do.

This is being done totally from scratch and I have a lot of freedom to
create whatever needs to be done. So if there is something else I
need to add or change to get this to work, I can do so.

Any help is appreciated, just please don't talk too technical or it
will be way over my head.

Sharon
 
Sharon,

It is not a good idea to have the 6 queries. You just need one. I
can say this with confidence, even though I can't grasp your meaning
at all regarding the nature of the protocols, subjects, observations,
and the relationships between these entities. If you want a subform
that lists data related only to a selected protocol, you can refer to
the control, whether it be textbox or combobox or option group, where
the protocol is selected. You do this in the criteria of the protocol
(or most likely it is ProtocolID) field in the query that the subform
is based on, by using syntax such as...
[Forms]![NameOfForm]![NameOfControl]

- Steve Schapel, Microsoft Access MVP
 
Steve,
I originally had the 6 queries so that I would have a subset that
showed what names went with each protocol. The form is not going to
be the answer I don't think, because it seems to just show what data
has already been entered. I guess I am saying it all wrong as to what
I am trying to do.

The part you saymakes me think of a form that shows information already entered and
not a partially filled in form ready for more data to be entered.

Let's say that I have a table called names that has a list of 100
different names, and a table called protocols that has 6 different
protocols. Each name can only belong to one protocol. During the
course of the study, daily observations are done on each protocol and
the names associated with them.

Let's say one protocol has 15 names associated with it. Instead of
having to create 15 records each day by entering in the protocol and
the name, I was trying to find a way to automatically populate
something with just those values entered and the rest of the variables
would then be ready to have data entered into them.

Example

1. Pick protocol (data entry person picks from drop-down list)
THEN
protocol, name, (both automatically filled in), date, time, initials,
(data entry person fills those in), then 6 more variables (that
default to 0, but have a drop down list of 0, 1,2,3,4,5) that the data
entry person would only enter if not 0.

This form (or whatever is used) would show all 15 records at one time.

Sharon


Sharon,

It is not a good idea to have the 6 queries. You just need one. I
can say this with confidence, even though I can't grasp your meaning
at all regarding the nature of the protocols, subjects, observations,
and the relationships between these entities. If you want a subform
that lists data related only to a selected protocol, you can refer to
the control, whether it be textbox or combobox or option group, where
the protocol is selected. You do this in the criteria of the protocol
(or most likely it is ProtocolID) field in the query that the subform
is based on, by using syntax such as...
[Forms]![NameOfForm]![NameOfControl]

- Steve Schapel, Microsoft Access MVP


I am working with Access 2000. I have a table with protocol names, a
table with subject names, and an observation table. I have 6
protocols and each one uses different names from the names table. I
created 6 queries (one for each protocol) that shows only the names
associated with them.

What I want to be able to do is have a form that lists the 6
protocols. When you choose a protocol, a sub form pops ups with all
the names belonging to that protocol so that all you have to do is
enter the date, time, and initials of the observer(s). The rest of
the fields (6 more dealing with behavior) all default to 0 (meaning
normal) and you would then just change that number (from a list
0,1,2,3,4,5) if needed.

I thought at first that this should be simple, but I have put in over
40 hours and still have nothing usable.

I have attached a gif that shows sort of what I am trying to do.

This is being done totally from scratch and I have a lot of freedom to
create whatever needs to be done. So if there is something else I
need to add or change to get this to work, I can do so.

Any help is appreciated, just please don't talk too technical or it
will be way over my head.

Sharon
Click to expand...
Click to expand...
 
Back
Top