Update Form

[knowshowrosegrows]

I have a form [frmMeasures] where the user inputs a record to a table
[tblUtilization_Measures]. Once they tab out of that form I don't want them
to be able to scroll around in the records, but sometimes they do need to go
back to an established record and edit it.

I have created another form with all the fields [frmUpdate_Measures]. A
query that searches the main table is the record source for the form. I have
created a ParamForm [Update_Param_Form] for them to use to choose the
specific record to update.

I have successfully set it up so when they open the [frmUpdate_Measures]
they get the [Update_Param_Form] and choose the record they want. These
steps will get the query to produce the proper record, but I can't get the
[frmUpdate_Measures] to open to that specific record for them to update.

Any suggestions?

 

[KARL DEWEY]

[frmUpdate_Measures] must open AFTER ParamForm [Update_Param_Form] has
selected the specific record to update.

 

[knowshowrosegrows]

Thankyou - that is very helpful. I have also read about using a wizard to
create a combo box that will find an exact record. I made one of those and
it works great. The code behind it is:

Private Sub Combo31_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[RecordID] = " & Str(Nz(Me![Combo31], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

The problem is that the form makes all the entered records available to the
user. How can I change this code or the form or the combo box so that the
user can see and update ONLY the record they chose in the combo box?




--
Thanks

[frmUpdate_Measures] must open AFTER ParamForm [Update_Param_Form] has
selected the specific record to update.
--
KARL DEWEY
Build a little - Test a little

I have a form [frmMeasures] where the user inputs a record to a table
[tblUtilization_Measures]. Once they tab out of that form I don't want them
to be able to scroll around in the records, but sometimes they do need to go
back to an established record and edit it.

I have created another form with all the fields [frmUpdate_Measures]. A
query that searches the main table is the record source for the form. I have
created a ParamForm [Update_Param_Form] for them to use to choose the
specific record to update.

I have successfully set it up so when they open the [frmUpdate_Measures]
they get the [Update_Param_Form] and choose the record they want. These
steps will get the query to produce the proper record, but I can't get the
[frmUpdate_Measures] to open to that specific record for them to update.

Any suggestions?

 

[KARL DEWEY]

I do not do code.
I would have the form fed from a query and use the AfterUpdate event of the
combobox to refresh the query.
--
KARL DEWEY
Build a little - Test a little

Thankyou - that is very helpful. I have also read about using a wizard to
create a combo box that will find an exact record. I made one of those and
it works great. The code behind it is:

Private Sub Combo31_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[RecordID] = " & Str(Nz(Me![Combo31], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

The problem is that the form makes all the entered records available to the
user. How can I change this code or the form or the combo box so that the
user can see and update ONLY the record they chose in the combo box?




--
Thanks

[frmUpdate_Measures] must open AFTER ParamForm [Update_Param_Form] has
selected the specific record to update.
--
KARL DEWEY
Build a little - Test a little

I have a form [frmMeasures] where the user inputs a record to a table
[tblUtilization_Measures]. Once they tab out of that form I don't want them
to be able to scroll around in the records, but sometimes they do need to go
back to an established record and edit it.

I have created another form with all the fields [frmUpdate_Measures]. A
query that searches the main table is the record source for the form. I have
created a ParamForm [Update_Param_Form] for them to use to choose the
specific record to update.

I have successfully set it up so when they open the [frmUpdate_Measures]
they get the [Update_Param_Form] and choose the record they want. These
steps will get the query to produce the proper record, but I can't get the
[frmUpdate_Measures] to open to that specific record for them to update.

Any suggestions?