I use the "Command Button Wizard" to open a form that applies filter in it...It works perfect but it never allows me to edit the fields in the filtered record. What shall I do so that I can edit with the fields?
Pls help, Thx...
Here is the code below:
Private Sub cmdCustRecord_Click()
On Error GoTo Err_cmdCustRecord_Click
Dim stDocName As String
Dim stLinkCriteria As String
I don't see any reason why you would not be able to edit data into the form FCustEdit just because it's open with the code you posted. Is the data editable when you open the form manually from the database window?
Yes its editable in database window. In fact, if the FCustEdit is opened through switchboard,it can be edited...The problem only exist if I open FCustEdit from the other form and use a button to open and filter the CustName base on the CustName of the other form.
It's something like,if I open it using the button,the locked of the text fields are enabled...
Thnx for the help Sinndho.
I forgot to update you, I got the reason why I can't edit the table. It's because I'm opening two forms and is accessing the same table. If two queries accessing the same table,you can only edit the records in the first open query; the records will be locked automatically if you opened the second query.