Combobox value not saved - why

[Susan Bricker]

Greetings.

I have a form (frmDogs) that is invisible while a subsequent form
(frmPeople) is visible. The visible form sets a value for a combobox
(cboOwner) in the hidden form, makes the invisible form visible and then
closes. When the newly visible form (frmDogs) appears the combo box
(cboOwner) is displaying the correct information (set from the previous
form). There is no indication that anything is wrong when I save the
Dog record.

If I close frmDogs and then return to the recently saved record, the
combobox cboOwner is blank, meaning the record was not saved with the
data that was assigned to it prior to the save.

Some more info ...
cboOwner is bound to [peopleID] with the RowSource = SELECT
tblPeople.peopleID, tblPeople.lname & ", " & tblPeople.fname & ("
"+tblPeople.midinit+".") & (" "+tblPeople.suffix+".") & " (" &
tblPeople.city & ", " & tblPeople.state & ")" AS ownerinfo
FROM tblPeople
ORDER BY tblPeople.lname;

if frmPeople the logic to set the cboOwner field in the invisible field
is ...

'Is the frmDogs form open?
blnDogs_Open = SysCmd(acSysCmdGetObjectState, acForm, "frmDogs") And
acObjStateOpen

If blnDogs_Open Then
If lngNewPID > 0 Then
Forms("frmDogs").Visible = True
If blnNewOwner = True Then
Forms("frmDogs")!cboOwner.Requery
Forms("frmDogs")!cboOwner = lngNewPID
blnNewOwner = False
End If
End If
End If

Any ideas?

Regards,
SueB

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

[Steve Jorgensen]

On Mon, 07 Nov 2005 12:17:11 GMT, Susan Bricker <sl*****@verizon.net> wrote:

Greetings.

I have a form (frmDogs) that is invisible while a subsequent form
(frmPeople) is visible. The visible form sets a value for a combobox
(cboOwner) in the hidden form, makes the invisible form visible and then
closes. When the newly visible form (frmDogs) appears the combo box
(cboOwner) is displaying the correct information (set from the previous
form). There is no indication that anything is wrong when I save the
Dog record.

If I close frmDogs and then return to the recently saved record, the
combobox cboOwner is blank, meaning the record was not saved with the
data that was assigned to it prior to the save.

Some more info ...
cboOwner is bound to [peopleID] with the RowSource = SELECT
tblPeople.peopleID, tblPeople.lname & ", " & tblPeople.fname & ("
"+tblPeople.midinit+".") & (" "+tblPeople.suffix+".") & " (" &
tblPeople.city & ", " & tblPeople.state & ")" AS ownerinfo
FROM tblPeople
ORDER BY tblPeople.lname;
If I understand your thinking here, this might b your problem. Assigning a
Row Source is not binding a control to a field. Assigning a row source tells
where the list of selections comes from, but assigning the Control Source
binds the control to a field. It's very much possible for a combo or list box
to have a Row Source, and be unbound.
if frmPeople the logic to set the cboOwner field in the invisible field
is ...

'Is the frmDogs form open?
blnDogs_Open = SysCmd(acSysCmdGetObjectState, acForm, "frmDogs") And
acObjStateOpen

If blnDogs_Open Then
If lngNewPID > 0 Then
Forms("frmDogs").Visible = True
If blnNewOwner = True Then
Forms("frmDogs")!cboOwner.Requery
Forms("frmDogs")!cboOwner = lngNewPID
blnNewOwner = False
End If
End If
End If

Any ideas?

Regards,
SueB

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

[SueB]

Steve,

Thanks for the explanation. I understand. I'll have to make sure to
save the [peopleID] field that is the primary key to the People record
and the foreign key that is saved in the Dog record (Owner field). So,
I'll save the [peopleID] as well of synchronizing the combobox
[cboOwner].

Regards,
SueB

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