473,388 Members | 1,217 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 software developers and data experts.

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 1139

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Fionnbarr Kennedy | last post by:
Hi all I have posted this problem before but am having no joy! I have an app written in Access 2000 which is based around a Form/Subform. The problem is with a new XP box only - the same app...
4
by: David Gunnarsson | last post by:
I'm using Access as a front-end to a MySql database, through ODBC. I have a form set up for entering information about projects and that form has, among other things, a subform where you can...
3
by: Simone | last post by:
Hi All, I have a Find Record button setup in most of my forms in order to find a specific customer's details. I have just noticed today though that this search will only find the customer if it...
5
by: ego | last post by:
Hi all , I had created the following Form/SubForm structure : MainForm SubForm A (SubForm of MainForm) SubForm B (SubForm of SubForm A) SubForm C (SubForm of SubForm B) SubForm D ...
1
by: tdmailbox | last post by:
I have the statment below that turns off allow edits so thatwhen I run the commend acCmdFind I only see the find menu rather then find and replace. The search button is on the parent form,...
9
by: PC Datasheet | last post by:
I'm stuck on something that seems should be easy and I need some help. My main form has an option group with five options. My subform chooses from different lists depending on which option is...
3
by: dhowell | last post by:
In reading some of the posts on this group, it appears as though it is not strait forward at all to filter a form, which has subforms, by criteria which are either on subforms or span more than one...
5
by: Ron | last post by:
Hi All, I've got a form called frmCust that has a subform on it called sfrmBalance. sfrmBalance's control source is a query called qryTrans4CustBal. sfrmBalance has one field on it called...
1
by: troy_lee | last post by:
I have a table (Table A). It has one field, a PK. It is in a 1:M with another table (Table B). I am having trouble with a form/subform setup to view the 1:M records. On the parent form, there is...
2
by: adigga1 | last post by:
Hello, I am running into an issue whereby, I'm attempting to create a form using a combo box selection (CPTcode). Once I make this selection the Charge price should auto populate accordingly. I'm...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.