Update Form

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

Guest

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?
 
[frmUpdate_Measures] must open AFTER ParamForm [Update_Param_Form] has
selected the specific record to update.
 
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


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


knowshowrosegrows said:
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?
Click to expand...
Click to expand...
 
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


knowshowrosegrows said:
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


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


knowshowrosegrows said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top