Form Won't Allow Additions

[Guest]

I have a form that just won't allow additions. I'ts a continuos form that has
a cbo in the head that is used to narrow down the selections cbo in the
detail section. Allow edits and additions are set to true. I have no idea
what's going on.

Please Help. Thanks, Robert

 

[Guest]

Rob,

What is the data source for your continuous form?

If you are using a query, it is probably not updateable.

Is you form actually a sub-form within another form? If so you may need to
add some code in the before update event that populates the field used in
your master-child relationship.

Dale

 

[Guest]

thanks for replying so fast.

q1) Data source is a join query.
q2) No the form is as I said in my first post.

You can't add records with a join query? If not, do you have any suggestion?

Thanks, Rob

 

[Guest]

Dale, there was no note from you on your last post. Could you pls send me
your response. Thanks, Rob

 

[Guest]

Sometimes when you link few tables in a query, it doesn't allow adding or
changing records, it will prompt you with the message that this record is not
updatetable (especialy when you link two tables not by the key).

Try to run the form RecordSource separatly and try to add a new record
directly without the form, if you can't then the probem is not with the form,
but with the RecordSource.

Sometimes I'm changing the UniqueProperty of the query to Yes, sometimes it
make it possible to update or add records.

If that doesn't help, I'm removing tables from the query, and in the form I
use Combo's Or SubForms instead to display the desired records.

 

[Guest]

The first query is the record source in question. I ran it and couldn't
update it. The second query does allow me to udate and add new. I don't see
what the difference is other than the tables and fields. What do you think?

Thanks, Robert


SELECT tblOPmeds.fldOPmedNo, tblOPmeds.fldPINo, tblOPmeds.fldOPmedLUno,
tblOPmeds.fldDose, tblOPmeds.fldUnits, tblOPmeds.fldRoute,
tblOPmeds.fldFrequency, tblOPmeds.fldStartDate, tblOPmeds.fldStopDate,
tblOPmeds.fldReasonStoped, tblOPmedsLU.fldClassification,
tblOPmedsLU.fldBRAND_NAME, tblOPmedsLU.fldGENERIC_NAME
FROM tblOPmedsLU INNER JOIN tblOPmeds ON tblOPmedsLU.fldOPMedsLUno =
tblOPmeds.fldOPmedLUno;
*********************************************************
SELECT tblDevices.fldPtDeviceNo, tblDevices.fldVisitNo,
tblDevices.fldDeviceNo, tblDeviceLU.fldDefibDeviceModName,
tblDeviceLU.fldDefibDeviceModNum, tblDevices.fldMode, tblDevices.fldRate,
tblDevices.fldReasonInterr, tblDevices.fldAthresh, tblDevices.fldApw,
tblDevices.fldLVthresh, tblDevices.fldLVpw, tblDevices.fldVentThresh,
tblDevices.fldVentPW, tblDevices.fldAimp, tblDevices.fldRVimp,
tblDevices.fldLVimp, tblDevices.fldHVBimp, tblDevices.fldHVX,
tblDevices.fldPwaveSens, tblDevices.fldRwaveSens, tblDevices.fldVpacePercent,
tblDevices.fldApacePercent, tblDevices.fldMDnote, tblDevices.Changes,
tblDeviceLU.fldManufactureID, tblDevices.fldSerialNo
FROM tblDevices INNER JOIN tblDeviceLU ON tblDevices.fldDeviceNo =
tblDeviceLU.fldDeviceNo;

 

[Guest]

I can see that your problem was solved by Allen Browne

http://www.microsoft.com/office/com...ries&mid=23bc18a8-5cac-42da-830c-a442e0d5e614

Good Luck with your project