Preloading a form with Data

[Carey27]

Im working on a database for a clinic this summer. I've created a form to input patient data and it is working well.

I now need a mechanism for the admins to update existing patient info. What I would like is for access to prompt the admin for the patient number (similar to a data dependent query/report) and then pull up the same form (or at least copy of the same form) with that record.

Is this possible without involving VBA (my VBA is pretty weak)?

Thanks,

 

[vbaInet]

Your enquiry is in two folds, one is a search form and the other is to open a second form filtered by the first. For both you need vba. I can provide you with some links?

 

[Carey27]

Thanks that would be great.

I tried googling it but might not have worded my search correctly...

 

[vbaInet]

Ok, for the search form, a rather lengthy read

http://baldyweb.com/BuildSQL.htm

It's a tutorial on building an sql string with vba and there are two pages. Towards the bottom of the first page there's a sample search db. The main section on the search form is in Page 2 but it would be beneficial to soak it all in.

Opening a second form filtered by the first (pretty simple):
http://baldyweb.com/wherecondition.htm

 

[missinglinq]

Would not using the Combobox Wizard's third option do this, without any code except that generated by the Wizard?

With your current form's properties set to

• Data Entry set to No
  [*]AllowAdditions set to Yes
• AllowEdits set to Yes

Add a ComboBox to your form.

The Combobox Wizard will pop up

Select "Find a record based on the value I selected in my combobox."

From the table or query the form is based on, click on the field you're searching by (a field that is unique for each record, such as a Patient ID Number) to move it to the right side.

Hit Next.

Size the column appropriately.

Hit Next.

Name the ComboBox.

Hit Finish.

Now you can drop the ComboBox down and scroll down to the Patient ID Number or you can start to enter the ID Number, and the ComboBox will "autofill" as you type. Hit <Enter> and the record will be retrieved for editing, no code involved!

Linq ;0)>

 

[vbaInet]

I keep forgetting the wizard missinglinq. But you will still need code for the second part.

 

[Carey27]

Missinglinq Thanks for the help. Ive used that for all but forms, but tonight i was trying to add a combo box for the same reason and the wizard no longer gave me the 3rd option.

Do you know why this might be?

 

[vbaInet]

You're not using the version of Access that has the option.

 

[Carey27]

Im using Access 2007 and had the option using for other forms. Not sure whats happening now. Ive checked Linqs Form properties and tried making forms from scratch to reset any other properties I might have changed...

 

[vbaInet]

I don't really use wizards but I can't see any problem with it actually. It should show up regardless. Is the form unbound?

 

[Carey27]

Got it working... Created a form from scratch using the wizard which tied it to the Lab table.

Thanks for pointing me in the right direction

 

[vbaInet]

Great! Glad you got it working.