edit record in new form

[mohamedmatter]

I want when click any record in search form edit this record in enterdata form to modify or delete
i attach data base to helps
many thanks

 

[pbaldy]

Can't look at the sample right now, but does this help?

http://www.baldyweb.com/wherecondition.htm

 

[Tieval]

If you allow data edits in the properties of the sub form you can edit them without problem.

 

[mohamedmatter]

Can't look at the sample right now, but does this help?

http://www.baldyweb.com/wherecondition.htm

i tired but error display i wait you to hlp me

 

[pbaldy]

Help with what? You haven't shown your code or what error you get.

 

[mohamedmatter]

Help with what? You haven't shown your code or what error you get.

i attach image to error

 

[pbaldy]

Did you see in the link the different syntax requirements for text vs numeric data types?

DoCmd.OpenForm "EnterData", , , "ID = " & Me.ID

 

[mohamedmatter]

Did you see in the link the different syntax requirements for text vs numeric data types?

DoCmd.OpenForm "EnterData", , , "ID = " & Me.ID

thank you
last question
how
How do I alert a user to click the id not any filed in the record or
how i opening enterdata when user click any filed in record as id filed in this exmple
end many thanks

 

[pbaldy]

You can put a label in the header that says "Double click on ID to edit" or something similar. You can put the same code behind all of the textboxes to have it work from any of the fields.