Form will not allow changes

  • Thread starter Thread starter ken_d128
  • Start date Start date
K

ken_d128

I have a form DeliveryInfo based on a query qyrDel
I made this from 2 other queries qryOrder and qryRepair
What I am looking for is the OrdershipDate and RepairShipDate to be
DelDate in form
I will only be shipping one order but may have a couple repair Orders
All my info comes up on Deliveryinfo form but I can not change DelDate
Need to be able to do this as customers reschedule.
If I run this form just using qryOrder as record source it runs fine
able to change OrdershipDate no problem

Any suggestions
Ken
 
the problem is probably not in the form, but in the query. multi-table
queries (including queries that are built on other queries) are often not
updateable. open the query by itself - not through the form. can you edit
the DelDate value in the query datasheet?

if not, then your query is not updateable; you'll need to come up with
another approach to displaying the data on the form (such as a main form and
one or more subforms) that allows you to build a simpler, updateable query.

if you *can* change a value directly in the query datasheet, then it's
likely that the problem is in the form design. make sure the form's
RecordsetType property is set to Dynaset, and the form's AllowEdits property
is set to Yes. if you still can't edit the value in the form, check to see
if any macros or VBA code are resetting either property at runtime, or
cancelling the control or form BeforeUpdate event, or running an Undo
action.

hth
 
well ran query and DelDate not updateable
so gonna have to find another approach
just need to get a form going based on that date
whether it is an order or a repair
thanks
Ken
 
Back
Top