473,406 Members | 2,956 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,406 software developers and data experts.

problem with subform linking

I have a main form with one subform that is used to record test
scores. The main form has the following fields:

WratStudentID ( a combo box with 2 fields - student id and student
name - . Stores the id)

WratGradeLevel
WratDateAdmin (mm/dd/yyyy)
WratForm

The subform has the following fields:

WratScoresID ( the student id)
DateAdmin
SubtestID
RawScore
StandardScore
Percentile
GradeEquivalent

There are 4 subtests that are entered via the subform.

I am linking them as follows:

Link child fields: WratScoresID; DateAdmin
Link master fields: WratStudentID; WratDateAdmin

Everything works fine when entering a student for the first time. The
date administered and student id are properly written to the subform's
underlying table. However, if I go to enter another main record for
that student, as soon as I enter the student id, it pulls up all the
subform records that are out there for that student, even though the
date administered has not been entered. It appears as though it is
ignoring the Date Admin linking criteria.

Any Ideas?

TIA

Feb 28 '07 #1
0 1716

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

Similar topics

3
by: Diana Gard | last post by:
Perhaps this is a design flaw, please let me know. I'm using Access 2000. I have a form with a tab control and 5 subforms within those tabs. The forms match with the tables: Client main,...
4
by: tlaker10 | last post by:
Access 2000- my form has fields for “name”, “arrival”, “departure” and “site nbr”. Can I make a subform under “name” that keeps a history of all previous entries to arrival/departure/site nbr so...
4
by: Dave Boyd | last post by:
Hi, I have two very similar forms each with a subform. The main form gets a few fields from the user and passes this back to a query that the subform is bound to. The requery is done when the...
1
by: Terry | last post by:
Hello, Has anyone experienced the following problem following an Upsize from Access 97 to SQL 2000 using the MS Upsize Wizard? Or can anyone see what the problem might be. Before Upsize...
1
by: NBruch | last post by:
Ok let me explain what im trying to do: i need a combo box which needs to be linked to a listbox (or combo box doesnt matter which really) then the listbox should bring up the record in a...
2
by: brenda.stow | last post by:
error msg " An error occured while referencing the object. You tried to run a visual basic procedure that improperly references a property or method of an object" This msg occurs everytime I add a...
9
by: Ecohouse | last post by:
I have a main form with two subforms. The first subform has the child link to the main form identity key. subform1 - Master Field: SK Child Field: TrainingMasterSK The second subform has a...
8
by: Simon | last post by:
Dear reader, The syntax for the VBA code to change the RowSource of a Form is: Forms!FormName..RowSource = "TableOrQueryName"
10
by: Chinde | last post by:
Hi I'm having problems with a subform, I'm using access 2007 but the DB's format is 2003, running os Xp. This is the problem, I have a main form which is set to be a single form and will auto...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
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
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...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.