How to add edit button...

  • Thread starter Thread starter SF
  • Start date Start date
S

SF

Hi,

I have an unbound form that have a combobox ([ID]) use to supply the id. On
the unbound form I have a subform display related records in datasheet view,
records are normally lock from editing.

Now I want to put a Edit button on each row, so that user can click on the
button open another form with specified record for editing. How to do that?

(I remember seeing this groups having a code to put on a hyperlink filed
(not sure) )

SF
 
You can't put a button for editing on a datasheet form so if you want
to keep your subform in datasheet view you have to code the edit
function to an event. In this case, you could code the OnDouble-Click
event to open your editable form to the record you are on. You may have
to apply a filter based on the record you've selected. What is the your
editable form's RecordSource property set to?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
Edit button and no adds 8
New Record- Make all field editable. 4
Detect which tab ... 1
Allow Edits to Subform 2
I can't get this code to work 1
Recordset.Clone Help Needed 8
subform based on external SQL won't requery 1

Back
Top