Previewing changes before update

[gtobey]

I would like to...
1) Enter some criteria in a form.
2) Click on a command button to popup a list of records meeting my criteria
3) Have a message box ask if I want to change the records selected to some value I've entered on the form in an unbound textbox.
4) Update the records or not as appropriate.

I'm having two problems 1) Anything I get to popup only shows a single record. 2) Getting the criteria from step1 above to pass to the update code. If anyone has some samples or suggestions I'd be really grateful.

P.S. I posted this in the VBA code section, but received no responses. Really could use some help. Thanks

 

[DougP]

I would add a subform to your main form.
Then pass the record(s) to it, it will show one or as many as match.


DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[Guest_imported]

I have something that I use on my form that may be of some use.

I have two subforms on my main form and each can contain multiple records. I have found it difficult to view all the records at the same time so I can make sure I have entered all the info in right. Its a bit of a pain in the but to have to click from record to record to ensure that changes have been made.

Instead of using a popup form, I have chosen to do a record review using a listbox on my main form (I'm sure you could just as easily do it on a popup form though).

I made a query that is based on the record number of my main form so when the query is run from the current form, it will show the corresponding info for only that record.

The query results are shown in the listbox.

I have the main form do a requery of the query that the listbox is based on so as you make changes, the summary listbox will show the corresponding changes. I can view multiple records at the same time by using this method. All you have to do then is lock the listbox so it only can be used to view.


For my main form I use this:
Private Sub Form_Current()
Me!FundingSummary.Requery
Me!ClientSummary.Requery
End Sub

Hoep this may help you.