Double Click feature is where in this database?

[Z1nkstar]

Okay I was under the impression that there was a double click feature on the item in this form but apparently it doesn't or I cant find it but when I double click the item it opens the edit feature???

There is supposed to be a double click that opens the edit feature but another problem is that it only work on the first record in the form???

I looked at the query also looked at the Table and criteria nothing was anywhere but I would hope that there is another way to make a double click event that I am just missing???

Here are some pictures of the database and the problems I am facing.


DLDB.zip

[June7]

I opened the form and there are no records. There is also no code in the form module.

The double click event is On Dbl Clk on the Event tab.

[Z1nkstar]

DLDB.zip
try this database

[June7]

The code is in the Detail section OnDblClk event, not the Item textbox.

The code works for me.

[Z1nkstar]

Well I have tried and tried But this is my conclusion:
The problem is that the first record will open the edit form but the rest of the records will not.
On the other forms it works but on the Active form it doesn't work for the rest of them only the first record.

[June7]

The form displayed in your original post is frmFabrication_Schedule_Active. The code works when the form is opened independently. No idea why it fails when a subform. The code for all the forms is associated with the Detail section.

I don't use macros, only VBA. Here are guidelines for debugging macro http://support.microsoft.com/kb/89610.

I also don't use Navigation Form.

[Z1nkstar]

Okay well i guess I will have to just figure it out idk i cant get it to work either way even the way you said that it does work I just get nothin

[June7]

This is weird. Now the form is not working even when opened independently. I swear it was.

I added a textbox bound to FabID and now the double click on any record opens form to selected record.

[Z1nkstar]

What bound did you add???

[June7]

A textbox with ControlSource set to FabID field.

[Z1nkstar]

That works for me as well thanks do you know how I could change that is there not a way?

[June7]

Change what? You don't want the textbox on form? Just set it as not visible.

[Z1nkstar]

well duh ok now I feel stupid ha thanks