Combo box does not update field.

[Robert Johnson]

Hi all. I have a combo box populated by tblPropMaster that writes to
tblInvoiceHdr. I can pull down the combo box and see the choices but cannot
select any. It just beeps and does nothing. Any ideas?

TIA

Robert

 

[Duane Hookom]

What is the control source property of the combo box? If you want it to
update a value in the form's record source, then it should be a field name
like:
Control Source: [MyField]

 

[Robert Johnson]

Yup. The field name is there. The pull down works but I can't make any
changes.

Robert

What is the control source property of the combo box? If you want it to
update a value in the form's record source, then it should be a field name
like:
Control Source: [MyField]

--
Duane Hookom
MS Access MVP
--

Hi all. I have a combo box populated by tblPropMaster that writes to
tblInvoiceHdr. I can pull down the combo box and see the choices but
cannot
select any. It just beeps and does nothing. Any ideas?

TIA

Robert

 

[Ken Snell [MVP]]

Chances are that your form's RecordSource query is not updatable. Or that
you have your form's AllowEdits property set to No. Either of these would
mean that your form will not let you edit data.

You'll need to post info re: your form's RecordSource query (such as the SQL
statement, the tables' structure, etc.) so that we might provide some
suggestions.

--

Ken Snell
<MS ACCESS MVP>

Yup. The field name is there. The pull down works but I can't make any
changes.

Robert

What is the control source property of the combo box? If you want it to
update a value in the form's record source, then it should be a field name
like:
Control Source: [MyField]

--
Duane Hookom
MS Access MVP
--

Hi all. I have a combo box populated by tblPropMaster that writes to
tblInvoiceHdr. I can pull down the combo box and see the choices but
cannot
select any. It just beeps and does nothing. Any ideas?

TIA

Robert

 

[Robert Johnson]

Ken, The form Allow edits is set to yes. Here is the sql query for the form
query

SELECT tblInvoiceHeader.InvoiceHeaderID,
tblNewProductionCompanies.ProductionCompanyName, tblNewShows.ShowName,
tblNewShows.BillToContactName
FROM (tblNewProductionCompanies INNER JOIN tblNewShows ON
tblNewProductionCompanies.ProductionCompanyID =
tblNewShows.ProductionCompanyID) INNER JOIN tblInvoiceHeader ON
tblNewShows.ShowID = tblInvoiceHeader.ShowID;

HTH,

Robert

Chances are that your form's RecordSource query is not updatable. Or that
you have your form's AllowEdits property set to No. Either of these would
mean that your form will not let you edit data.

You'll need to post info re: your form's RecordSource query (such as the SQL
statement, the tables' structure, etc.) so that we might provide some
suggestions.

--

Ken Snell
<MS ACCESS MVP>

Yup. The field name is there. The pull down works but I can't make any
changes.

Robert

What is the control source property of the combo box? If you want it to
update a value in the form's record source, then it should be a field name
like:
Control Source: [MyField]

--
Duane Hookom
MS Access MVP
--

Hi all. I have a combo box populated by tblPropMaster that writes to
tblInvoiceHdr. I can pull down the combo box and see the choices but
cannot
select any. It just beeps and does nothing. Any ideas?

TIA

Robert

 

[Ken Snell [MVP]]

It appears that your query does not include the primary key fields from
tblNewProductionCompanies and tblNewShows tables, so I would imagine that
the query is nonupdatable. If you open the query in datasheet view, will it
let you add new record or edit data? I doubt that it will.

There are many possible reasons why a query can be nonupdatable. See these
MS Knowledge Base articles for more info:

ACC2000: Cannot Edit or Update Record on a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;209571&Product=acc

ACC2000: Status Bar Displays "Recordset Not Updateable" Message When You Try
to Update a Linked Table
http://support.microsoft.com/default.aspx?scid=kb;en-us;304179&Product=acc

INFO: Troubleshooting Errors That May Occur When You Update Data in Queries
and in Forms
http://support.microsoft.com/default.aspx?scid=kb;en-us;328828&Product=acc

ACC: Update Query Based on Totals Query Fails
http://support.microsoft.com/default.aspx?scid=kb;en-us;116142&Product=acc


--

Ken Snell
<MS ACCESS MVP>

Ken, The form Allow edits is set to yes. Here is the sql query for the form
query

SELECT tblInvoiceHeader.InvoiceHeaderID,
tblNewProductionCompanies.ProductionCompanyName, tblNewShows.ShowName,
tblNewShows.BillToContactName
FROM (tblNewProductionCompanies INNER JOIN tblNewShows ON
tblNewProductionCompanies.ProductionCompanyID =
tblNewShows.ProductionCompanyID) INNER JOIN tblInvoiceHeader ON
tblNewShows.ShowID = tblInvoiceHeader.ShowID;

HTH,

Robert

Chances are that your form's RecordSource query is not updatable. Or that
you have your form's AllowEdits property set to No. Either of these would
mean that your form will not let you edit data.

You'll need to post info re: your form's RecordSource query (such as the SQL
statement, the tables' structure, etc.) so that we might provide some
suggestions.

--

Ken Snell
<MS ACCESS MVP>

Yup. The field name is there. The pull down works but I can't make any
changes.

Robert

What is the control source property of the combo box? If you want it to
update a value in the form's record source, then it should be a

field
name

like:
Control Source: [MyField]

--
Duane Hookom
MS Access MVP
--

Hi all. I have a combo box populated by tblPropMaster that writes to
tblInvoiceHdr. I can pull down the combo box and see the choices but
cannot
select any. It just beeps and does nothing. Any ideas?

TIA

Robert

 

[Robert Johnson]

Thanks Ken for pointing me in the right direction..

Robert

It appears that your query does not include the primary key fields from
tblNewProductionCompanies and tblNewShows tables, so I would imagine that
the query is nonupdatable. If you open the query in datasheet view, will it
let you add new record or edit data? I doubt that it will.

There are many possible reasons why a query can be nonupdatable. See these
MS Knowledge Base articles for more info:

ACC2000: Cannot Edit or Update Record on a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;209571&Product=acc

ACC2000: Status Bar Displays "Recordset Not Updateable" Message When You Try
to Update a Linked Table
http://support.microsoft.com/default.aspx?scid=kb;en-us;304179&Product=acc

INFO: Troubleshooting Errors That May Occur When You Update Data in Queries
and in Forms
http://support.microsoft.com/default.aspx?scid=kb;en-us;328828&Product=acc

ACC: Update Query Based on Totals Query Fails
http://support.microsoft.com/default.aspx?scid=kb;en-us;116142&Product=acc


--

Ken Snell
<MS ACCESS MVP>

Ken, The form Allow edits is set to yes. Here is the sql query for the form
query

SELECT tblInvoiceHeader.InvoiceHeaderID,
tblNewProductionCompanies.ProductionCompanyName, tblNewShows.ShowName,
tblNewShows.BillToContactName
FROM (tblNewProductionCompanies INNER JOIN tblNewShows ON
tblNewProductionCompanies.ProductionCompanyID =
tblNewShows.ProductionCompanyID) INNER JOIN tblInvoiceHeader ON
tblNewShows.ShowID = tblInvoiceHeader.ShowID;

HTH,

Robert

Chances are that your form's RecordSource query is not updatable. Or that
you have your form's AllowEdits property set to No. Either of these would
mean that your form will not let you edit data.

You'll need to post info re: your form's RecordSource query (such as

the
SQL

statement, the tables' structure, etc.) so that we might provide some
suggestions.

--

Ken Snell
<MS ACCESS MVP>

Yup. The field name is there. The pull down works but I can't make any
changes.

Robert

What is the control source property of the combo box? If you want

it
to

update a value in the form's record source, then it should be a field
name
like:
Control Source: [MyField]

writes
to

tblInvoiceHdr. I can pull down the combo box and see the

choices
but

cannot
select any. It just beeps and does nothing. Any ideas?

TIA

Robert