Edit filtered record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have created a tabular form that lists brief description about every entry
in one of my tables. when clicking on any of these lines, a new form will
open displaying all information stored for that record.

This is working fine when I want to display records. But I can not edit the
records if they are filtered.

Any idea how to solve this?

Thank you
 
FreeMaster said:
Hi,
I have created a tabular form that lists brief description about every entry
in one of my tables. when clicking on any of these lines, a new form will
open displaying all information stored for that record.

This is working fine when I want to display records. But I can not edit the
records if they are filtered.

Any idea how to solve this?

Thank you
Click to expand...

You mean that the form you open to display the detailed information doesn't
allow you to edit the record? This could be for several reasons. Are you
by any chance opening the form read-only? (Check the code that opens the
form when you click a line on the summary form.) Is the form's AllowEdits
property set to No? (Check the Data tab of the form's property sheet in
Design View.) Is the form based on a query that is not updatable? (If the
form is based on a query, try opening that query all by itself as a
datasheet. Can you edit its records or add a new one?)
 
Hi Dirk,
I have 2 forms, one is the MAIN and the other is PROJECTS INFORMATION EDIT.
I added a link in my MAIN form to go to PROJECTS INFORMATION EDIT. I was able
to edit projects information.

Later, I had so many projects and it is a hastle for a user to browse
through records in PROJECTS INFORMATION EDIT to find his project and update
it. There for, I created one form named PROJECTS LIST and linked the forms as
follows:

MAIN --> PROJECTS LIST (tabular listed) --> PROJECTS INFORMATION EDIT

I created the link between PROJECTS LIST and PROJECTS INFORMATION EDIT using
command button wizard, which makes me able to click on that button and go
directly to that specific record in PROJECTS INFORMATION EDIT.

Here where I have the problem, I can not edit the record.

I hope this explain it all.

Thank you Dirk.
WL
 
FreeMaster said:
Hi Dirk,
I have 2 forms, one is the MAIN and the other is PROJECTS INFORMATION EDIT.
I added a link in my MAIN form to go to PROJECTS INFORMATION EDIT. I was able
to edit projects information.

Later, I had so many projects and it is a hastle for a user to browse
through records in PROJECTS INFORMATION EDIT to find his project and update
it. There for, I created one form named PROJECTS LIST and linked the forms as
follows:

MAIN --> PROJECTS LIST (tabular listed) --> PROJECTS INFORMATION EDIT

I created the link between PROJECTS LIST and PROJECTS INFORMATION EDIT using
command button wizard, which makes me able to click on that button and go
directly to that specific record in PROJECTS INFORMATION EDIT.

Here where I have the problem, I can not edit the record.

I hope this explain it all.

Thank you Dirk.
WL
Click to expand...

Did you check all the things I mentioned? You say you used the command
button wizard to create the button on [PROJECTS LIST] that opens [PROJECTS
INFORMATION EDIT]. Please post the code from the button's Click event
procedure.

Also, please verify that, if you just open [PROJECTS INFORMATION EDIT]
manually from the database window, you can edit the records.
 
FreeMaster said:
Hi Dirk,
I already tried opening the form manualy and it worked. but it won't
if I open it using the link.

below is the On click command
-----------------------
Private Sub Open_edit_form_Click()
On Error GoTo Err_Open_edit_form_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "BI Details - Change details"

stLinkCriteria = "[BI Number]=" & "'" & Me![BI Number] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Open_edit_form_Click:
Exit Sub

Err_Open_edit_form_Click:
MsgBox Err.Description
Resume Exit_Open_edit_form_Click

End Sub
Click to expand...

I don't see anything there that would make the opened form uneditable.
The only thing in that code that I can see that might even possibly be
wrong is if the field [BI Number] is not a text field. The code as
written builds stLinkCriteria with quotes around the value of Me![BI
Number], which is correct if [BI Number] is defined in the table as a
text field, and incorrect otherwise. So you should verify that [BI
Number] is a text field, despite its name.

But even if that is wrong, I don't see why it would make the form
uneditable -- I'd just expect an error when you open it. So I'm puzzled.
Is there any code in the Open or Load event of the form [BI Details -
Change details] ?
 
Back
Top