MS Access - Forms questions — OZONE Asylum, home of the Mad Scientists

This page's ID: 28777

Edit Post

Who can edit a post?	The poster and administrators may edit a post. The poster can only edit it for a short while after the initial post.

Your User Name:
Your Password:
Login Options:	Remember Me On This Computer

Your Text: Insert Slimies » Insert UBB Code » Close Last Tag \| All Tags UBB Help	I figure with all the coder types in here someone might be able to help me out with an Access question. I am creating a database of pharmacists that work at my company. I have one table that stores information about the pharmacist and one that stores information on their licenses (a pharmacist can be licensed in more than one state at a time.) The two tables are linked on Employee ID# since that is a unique number. I have one form that users fill out to add a new pharmacist and one they fill out to add a new license. What I would like to do is to have the user fill out the pharmacist information first and then click a button to open a new form to fill out the license information. Currently it works like that but when the license form opens the user has to retype the Employee ID for each new license they add. Ideally, I'd like the Employee ID to automatically populate based on what they type when they're adding the new pharmacist. Is that clear as mud? The VB code on the "Add New License" button so far is: [code] Private Sub Command22_Click() DoCmd.OpenForm "frmLicenseAdd", acNormal, , , acFormAdd End Sub [/code] :::[url=http://www.11oh1.net]11oh1[/url]::: Loading...
Options:	Enable Slimies Enable Linkwords

Edit Post