Combo Box Selection

[PHisaw]

Hi,
I have a form that opens to specific record when a check box is selected on
another form. It is based on a query with SQL below:

SELECT tWarrantyInfo.TotalCost, tWarrantyInfo.WarrantyType,
qGeneralInfo.JobNumber, tStatus.Warranty, tStatus.Invoiced,
tStatus.Completed, qGeneralInfo.CustomerName, qGeneralInfo.Address,
qGeneralInfo.City, qGeneralInfo.State, qGeneralInfo.Zip, qGeneralInfo.Phone,
qGeneralInfo.ContactName, qGeneralInfo.PumpType, qGeneralInfo.Fax,
qGeneralInfo.Model, qGeneralInfo.PurchaseOrderNumber,
qGeneralInfo.SerialNumber, tWarrantyInfo.WarrantyComments,
qGeneralInfo.MachineAssignment, qGeneralInfo.JobAssignment
FROM (tStatus INNER JOIN qGeneralInfo ON tStatus.JobNumber =
qGeneralInfo.JobNumber) INNER JOIN tWarrantyInfo ON qGeneralInfo.JobNumber =
tWarrantyInfo.JobNumber
WITH OWNERACCESS OPTION;

I'm not sure what "WITH OWNERACCESS OPTION" means. Not sure I've ever seen
this before. Anyway, the problem is with a combo box I've put on the form.
I went thru the Wizard and selected to type in the values I wanted as I only
have two to choose from and to store the value in field in query. When I'm
in form view and try to make a selection from the table, I can't. No
messages, just the tone sound. If I remove the field name to hold value in,
it will work but I need this info to run a report at a later time.
I'm not sure what I need to do to correct this problem? If anyone can help,
I would sure appreciate it.
Thanks in advance,
Pam

 

[Klatuu]

WITH OWNERACCESS OPTION is only meaningful in a database where WorkGroup
Security is used and it is a multi user environment. It allows the user
running the query the same permissions as the owner of the query.

The remainder of your question is not very clear. Are you trying to use the
Combo to search form something? Is the combo a bound control? What are the
row source and row source type set to?

 

[PHisaw]

Klatuu,

Thanks for the reply. I'm sorry I should have included more info about the
combo box. I wanted to use it to select whether the WarrantyType was either
Factory or House. At first it was bound to the WarrantyType field on the
table. I read thru other posts and thought I had it by making the combo box
unbound, row source type was a value list and row source was "Factory";
"Value". Then I put a text box "txtWarrantyType" bound to WarrantyType as a
hidden field and had the AfterUpdate of the combo box set to

Me.TxtWarrantyType = Me.CboWarrantyType

This only returns a "recordset not updateable" error message. I only have
two tables on the query for the form. I can't figure out what's causing this.

Thanks,
Pam