cant edit a datasheet

[pduncan]

I have a form where the user clicks his/her name on a listbox and then a (subform) data sheet is populated with their records.

Ideally I would like to have the user double click a row in the data sheet and have this row's data open in a new form that the user would use to edit. I have asked this question in another forum, and had some responses but I can't figure this out.

Anyway, in the meantime, I thought about just having the user edit the data that is in the (subform) datasheet. But although the allow edits property is set to yes, you still can not change any of the data.

Thanks, PDUNCAN
Memphis, TN - USA
When I die, I want to die like my grandfather-- who died peacefully in
his sleep. Not screaming like all the passengers in his car.

 

[PHV]

But although the allow edits property is set to yes, you still can not change any of the data
Is the underlaying query updatable ?
Take a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[pduncan]

Thanks again -
thought this me be a more appropriate forum...

I read the information at the link and from what I can tell it is updatable (I think)

if you can tell from the underlying queries SQL, here it is.

SELECT tblController.RCName, tblEvents.Date, tblEvents.Event, tblEvents.LocationName, tblEvents.Complete, tblEvents.Attended, tblEvents.Amount, tblEvents.Comments
FROM (tblController INNER JOIN tblEvents ON tblController.RCNo = tblEvents.Controller) INNER JOIN tblLocations ON tblEvents.LocationName = tblLocations.BranchName
WHERE (((tblController.RCName)=[Forms]![frmSearch]![lstController]));

Thanks,
PDUNCAN
Memphis, TN - USA

 

[PHV]

To know if a query is updatable open it in the database window and see if you can modify a field.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[pduncan]

OK - looks like it isnt. darn. Since it isnt, is there any easy way to overcome this?

Thanks,
PDUNCAN
Memphis, TN - USA

 

[PHV]

Reread carefully the article I pointed you to.
For me, lack of PK in your SELECT fields list and I'd use tblEvents at the 1rst place in the FROM clause.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244