Need help with Tab Control (unable to update some fields)

[Susan Bricker]

Hi. I'm having trouble enabling fields on the 2nd Tab in a form with
the Tab Control. Can you help me?

The form (frmPeople) has a Tab Control with two tabs:
General Information and Judge Information. The RecordSource for the
form is a Query joining two tables:
tblPeople (name, address, phone, ...) and tblJudges (foreign
key=peopleID, and specific judge information).

The query is:
SELECT tblPeople.peopleID, tblPeople.fname, tblPeople.midinit,
tblPeople.lname, tblPeople.suffix, tblPeople.addr1, tblPeople.addr2,
tblPeople.city, tblPeople.state, tblPeople.country, tblPeople.zipcode,
tblPeople.phone, tblPeople.altperson, tblPeople.email,
tblJudges.judgeID, tblJudges.n_qualdt, tblJudges.o_qualdt,
tblJudges.u_qualdt, tblJudges.n_licdt, tblJudges.o_licdt,
tblJudges.u_licdt
FROM tblPeople LEFT JOIN tblJudges ON tblPeople.peopleID =
tblJudges.peopleID
ORDER BY tblPeople.lname;

All the Judge fields (textbox controls) are on the 2nd Tab.

If a judge is already defined (has a People record and a Judge record)
then the form works fine. All the data is displayed. If I want to edit
the data, that works fine, also. I have an EDIT button that changes the
form properties to allow edits.

THE PROBLEM: When I open the form for a New Record ... the textbox
controls on Tab 2 (Judge Information) are not enabled.

I have a feeling it has something to do with being positioned in the
People Table but not haveing a newrecord positioned in the Judge Table.

HELP!!! Can you help?

Thanks.
SueB

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***