Urgent: Using a combo box to populate a form for updating record.

[ifraet]

Hi, everyone. I am working on a simple project but I am stuck. I want to create a form that allows a user to update a recordset from tbUsers and tbEmployment which share a one-to-many relationship. I want the user to use a combo to select UserID which then populates the form which contains textfields from tbUsers and a subform from tbEmployent. After making the necessary changes, the user will just click an update button. My project contains little code for it isnt a bulletproven one. But I realise to achieve the above, I need coding. Someone please save a poor laddie!

PS: the combo boxes in the mobile view of this site do not work.

[June7]

Actually, what you want can be done without code by using the intrinsic Access search and filter tools from the ribbon and the right click shortcut menu. However, for casual users those tools might not be intuitive enough and they are less versatile.

So, review this tutorial for one method http://datapigtechnologies.com/flash...tomfilter.html

Edits are committed to table when form closes, move to another record, or run save record code.

[ifraet]

Thanks so much for the help. But the link you provided is not working. :-( I

[ssanfu]

I just tried the web page June provided and it opened - the clip started playing....... using FireFox.

[ifraet]

Thanks. I think the problem is my trying to access it with my phone: the video doesnt play. I accessed the main site and saw many helpful topics under accessmain. I will use a computer tomorrow at a cyber cafe. Will get back to you as soon as I do that. Thanks so much!
.................................................. ................
I came, I saw, ...yet to conquer
.................................................. ................

[ifraet]

Hey, guys. I tried accessing the file with a brother's blackberry phone but it didn't play. All efforts to do it are to no avail. Could you please explain it here? Please....

[June7]

Why aren't you trying on a computer?

Bing: Access parameterized query wildcard

Here is another http://www.techonthenet.com/access/q...parameter3.php

[ifraet]

Thanks so much... I have read the operation described on that link. I do not see how it helps solve my problem. Can't I just use some VBA code at the After Update event of the Combo box to pull up the data to the textfields and the subform for update? Been reading about VBA lately. I think I can handle little code. Please... Thanks in advance.

[June7]

You can use the parameterized query technique to filter main form to the record for specified UserID. Then the subform will display only those records associated with the main form record.

Other techniques do not use parameterized query and involve a little more code. Although could be as simple as:

Me.Filter = "UserID=" & Me.comboboxname
Me.FilterOn = True

or as complex as http://allenbrowne.com/ser-62code.html