Subform not auto-generating a field

[johnwayneoftheseas]

Hello, all. I'm still struggling with a form I've been working on for a week. I'm not sure what the problem is, exactly, or whether I can even do what it is I'm trying to do. To save everyone's sanity, I've attached the zipped database.

In the end, what I would like is to be able to tab through frmDataEntryUNITEApplicantsCURRENT and enter the data as it looks now. However, it seems my ApplicantID fields are not auto-populating. Is there something I missed in my relationships? I've tried several incarnations (as you can see) and have had no luck.

Thank you in advance SO MUCH for any help!

 

[CEH]

uh.....No, you didn't attach anything
But without even looking it sounds like your subform is not linked to main form.
Put into design view. Click the subform.. look at properties.
Under "Link Child Field" and "Link Master Field".... anything there? Should be.

 

[johnwayneoftheseas]

Whoops! I'm sorry, my mistake.

 

[johnwayneoftheseas]

Curtis: Yes, they are correctly linked. However it seems that perhaps the problem is that the Application ID should be on the main form to act as a second master field. Does that sound right? (As I will always be using this form for application data entry, I don't foresee any issues with generating an application ID when I'm not trying to enter information about an application.)

 

[Scooterbug]

Might want to save it as a MDB file. Not everybody uses A2007 and you will generate more help if more ppl can see it

 

[johnwayneoftheseas]

Grr. I'm trying to change my "multivalued fields" so I can save it in an mdb file.

 

[johnwayneoftheseas]

Alright! Hopefully this will work!

 

[CEH]

Well, where to start...... First, I would build some queries. Don't base forms on tables. Second look at some of these tables. Like table for College... there is a compound primary key....When you place the primary key from one table into another table as a foreign key you do not mark it as a primary key... that looks like what you did. In fact on that table it looks like EducationalInstitutionID should be the primary key.
Make those changes and go from there.... You shouldn't need to create new forms (thou might be easier) but just change the source from table to your queries..