Access 2010 - Multiple Rows in Form w/ checkboxes

[stevedefazio]

I currently have a query that produces a result set with a number of rows. Some columns are left blank for free-form data entry, and some of the columns are calculated values based on other columns.



What I need, is a form that displays all the data in table-form, with a checkbox at the end of each row which when checked, will populate a field with the user's name. Basically the user is just using the checkbox to certify that they've reviewed the data.

How should I do this? Is it a form? Do I need to use a sub-form/continuous form/etc? I'm an MS Access rookie, so I appreciate any help.

[June7]

How do you know the name of the user?

This will require code (macro or VBA) in button Click event. Something like:

Sub buttonname_Click()
Me.textbox = "username"
End Sub

[stevedefazio]

Thank you for that! I'd been hoping to avoid doing programming, but I guess it's unavoidable.

Any thoughts on the best way to get all the records to show up on a single form? When I have the query selected and hit "Create Form", it gives me each record as its own page.

[June7]

Set the form to Datasheet view or Continous and with Continuous can arrange controls to look like datasheet. For the latter will first have to 'ungroup' the controls, as the wizard probably grouped them. Select all the controls by click/sweep with the mouse curser then right click for shortcut menu > Layout > Remove. Now arrange and size controls individually.

[HuubVanOers]

Hi,
you can get the username with the environ function:
eg. txtUser = environ("USERNAME)

gr.
Huub