To Record in Form View from Query

[DrewBe]

I have a query run from FORM view using a button. To view records associated
with parameters built in the query. I would like to select the record and
view it back in the FORM view and continue on editing from there. Is it
possible to add a column in my query with this type of feature or something
along those lines?!

 

[Jeanette Cunningham]

Hi,
people usually do this sort of thing with 2 forms. The first form allows a
user to choose which record they want to edit. After they choose the record
there will be a button to click or sometimes a double click which opens the
second form with only the record that is to be edited.
Note with this system, the first form that chooses the record to edit needs
to be read only.

Jeanette Cunningham

 

[Jeanette Cunningham]

Hi,
people usually do this sort of thing with 2 forms. The first form allows a
user to choose which record they want to edit. After they choose the record
there will be a button to click or sometimes a double click which opens the
second form with only the record that is to be edited.
Note with this system, the first form that chooses the record to edit needs
to be read only.

Jeanette Cunningham

 

[Jeanette Cunningham]

Apologies for double posting, I don't know what happened there.
Jeanette Cunningham

 

[John W. Vinson]

I have a query run from FORM view using a button. To view records associated
with parameters built in the query. I would like to select the record and
view it back in the FORM view and continue on editing from there. Is it
possible to add a column in my query with this type of feature or something
along those lines?!

I'd suggest using the button to set the form's Filter property to display the
desired record, e.g.

Private Sub cmdFilterForm_Click()
If IsNull(Me!parameterbox) Then
Me.FilterOn = False
Me.Filter = ""
Else
Me.Filter = "[Fieldname] = " & Me!parameterbox
Me.FilterOn = True
End If
End Sub


John W. Vinson [MVP]