Populating form elements from database table

[macleodjb]

Hi guys,
I'm new to using VBA with access. I have a form with some checkboxes and textboxes that correspond to fields that are in my database table. What i would like to do is have a form pop up in the beginning asking the user for a job number and when the user clicks the submit button it will query the database retrieve records and then open and populate my form with the checkboxes and textboxes. How can i accomplish this?

 

[Remou]

The usual way is to use a bound form with bound controls. A form can be opened to a particular record, for example:

[tt]DoCmd.OpenForm "frmJobs",,,"JobNo=" & Me.JobNo[/tt]

It is always a good idea to look at the sample databases, in particular Northwind.

 

[macleodjb]

Ok so i have a form where i can enter the job number, on submit opens the form edit job. how can i get the open form to either hide or close itself after the edit job form has been opened?

 

[JoeAtWork]

   DoCmd.Close