468,765 Members | 1,384 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,765 developers. It's quick & easy.

1-many form and subform - why is this so hard to get it to work- db is normalized even...

I have this normalized database, and I don't understand why setting up
the forms is so hard for me. I have the main candidate entry form.
This is to enter in candidates who apply for a job. I have a tab
control with a page that shows if the candidate type is 1 of a few
types ( in code). Otherwise 2 pages show. 1 is for contact
information. This has an address subform and a phone subform. I can't
figure out how to show all address, while maintaining the combo box
changes per record, which won't seem to hold on a continuous or single
form. I have tried both.

Also, I have been trying to lock down code for only one of a
candidate's address to be allowed to ahve a primary checkbox checked.
Also that 1 must be checked. No luck there.

On the 2nd page, I have applications. I also have a sub-sub form for
activities, which go by application.

These 2 subforms have some conditional combos. If the combo choice
chosen is 1 answer a text box may come up - ie if an interview
scheduled is the activity, a date box comes up for the date of the
interview to be entered. But if the activity chosen is materials
forwarded, then the date box is hidden and the office combo is shown,
so that the office the materials were forwarded to can be chosen. If I
enter one record, the change stays for other records. I can scroll
through the records, and even though one might say offer extended was
the activity, its offer result combo is not shown, the interview date
text box is visible, because that was the last choice for an activity.
This form is set to single.

I have screen shots to show what I am saying:

http://www.geocities.com/misscrf/ima...howtextbox.jpg
shows 1 activity entered with the interview date showing because
interview scheduled is the activity chosen from the drop down.

http://www.geocities.com/misscrf/ima...dshowcombo.jpg
What activity 2 should look like if materials forwarded is chosen (
with the office combo showing)

http://www.geocities.com/misscrf/ima...owwrongbox.jpg
what is happening.

This is happening other places for me, so I am trying to find a fix
that I can everywhere.

Thanks for any help!

Nov 13 '05 #1
0 1006

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Fionnbarr Kennedy | last post: by
4 posts views Thread by David Gunnarsson | last post: by
3 posts views Thread by Simone | last post: by
9 posts views Thread by PC Datasheet | last post: by
3 posts views Thread by dhowell | last post: by
1 post views Thread by troy_lee | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.