subform control data source query not working

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
M

Mark Kubicki

on my main form [frmSpec] I have a combo control [cboManufacturer], and a
subform [fsubManufacturerAlternates]

On that subform [fsubManufacturerAlternates] is the combo control
[cboManufacturerAlt] whose data source is written as

SELECT Manufacturers.ManufacturerName
FROM Manufacturers
WHERE
(((Manufacturers.ManufacturerName)<>[Forms]![frmSpec]![cboManufacturer]))
ORDER BY Manufacturers.ManufacturerName;

however, it is not finding <>[Forms]![frmSpec]![cboManufacturer]

where should I be looking for this error?

I've checked the spelling,
and
the field Manufacturers.ManufacturerName , as well as it's source
Manufacturers are correct
and
when I type into the "parameter not found" prompt the value of
cboManufacturer, the query presents properly...

thanks in advance,
Mark
 
Its timing. there is no value in the control at the time the form opens.
you could do a number of things:

1: unbind the subform and use the mainform's oncurrent event to update the
subform.
or
2: store the value (from the main form) somplace else. another form, a
memory variable thats available before the form opens and change the query
to get the value there.
hth
Roger
 
i confused:
behind the control's "got focus" event there is code to requery the row
source, this is when the error occurs (not when the form opens) and ther
will always be a value in the field: forms!frmSpec.manufacturer?


roger said:
Its timing. there is no value in the control at the time the form opens.
you could do a number of things:

1: unbind the subform and use the mainform's oncurrent event to update
the
subform.
or
2: store the value (from the main form) somplace else. another form, a
memory variable thats available before the form opens and change the
query
to get the value there.
hth
Roger



Mark Kubicki said:
on my main form [frmSpec] I have a combo control [cboManufacturer], and a
subform [fsubManufacturerAlternates]

On that subform [fsubManufacturerAlternates] is the combo control
[cboManufacturerAlt] whose data source is written as

SELECT Manufacturers.ManufacturerName
FROM Manufacturers
WHERE
(((Manufacturers.ManufacturerName)<>[Forms]![frmSpec]![cboManufacturer]))
ORDER BY Manufacturers.ManufacturerName;

however, it is not finding <>[Forms]![frmSpec]![cboManufacturer]

where should I be looking for this error?

I've checked the spelling,
and
the field Manufacturers.ManufacturerName , as well as it's source
Manufacturers are correct
and
when I type into the "parameter not found" prompt the value of
cboManufacturer, the query presents properly...

thanks in advance,
Mark
Click to expand...
Click to expand...
 
try the "AfterUpdate" event

Mark Kubicki said:
i confused:
behind the control's "got focus" event there is code to requery the row
source, this is when the error occurs (not when the form opens) and ther
will always be a value in the field: forms!frmSpec.manufacturer?


roger said:
Its timing. there is no value in the control at the time the form opens.
you could do a number of things:

1: unbind the subform and use the mainform's oncurrent event to update
the
subform.
or
2: store the value (from the main form) somplace else. another form, a
memory variable thats available before the form opens and change the
query
to get the value there.
hth
Roger



Mark Kubicki said:
on my main form [frmSpec] I have a combo control [cboManufacturer], and a
subform [fsubManufacturerAlternates]

On that subform [fsubManufacturerAlternates] is the combo control
[cboManufacturerAlt] whose data source is written as

SELECT Manufacturers.ManufacturerName
FROM Manufacturers
WHERE
(((Manufacturers.ManufacturerName)<>[Forms]![frmSpec]![cboManufacturer]))
ORDER BY Manufacturers.ManufacturerName;

however, it is not finding <>[Forms]![frmSpec]![cboManufacturer]

where should I be looking for this error?

I've checked the spelling,
and
the field Manufacturers.ManufacturerName , as well as it's source
Manufacturers are correct
and
when I type into the "parameter not found" prompt the value of
cboManufacturer, the query presents properly...

thanks in advance,
Mark
Click to expand...
Click to expand...
Click to expand...
 
Back
Top