Go Back   Access World Forums > Microsoft Access Discussion > Forms

Thread Tools Rate Thread Display Modes
Old 11-03-2013, 05:17 PM   #1
Newly Registered User
Join Date: Oct 2013
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
bobbilockie is on a distinguished road
Form on click event coding

Iam very new to access.
I have a table called MAIN
A form called frmNew_Record
A Second Table named tblRecord
In the form used to create new records, there is a field named Department. Then a second field names Recordtype. I would like the user to be able to filter the choices of the Recordtype box by what they enter in the Department box. The second table has only 2 fields DeptName, and Recordtype. This is where I have listed all the possible choices. So there are say 10 records in this table that say DeptName “Exectutive Office” and a Recordtype . Each record lists another possible record type for that department.
I need a code that will tell the form, specifically the Recordtype box on the form (on click) to only display the drop down choices that relate to the specific Department already selected higher up on the form. I now it has to be something like this
Select Recordtype from recordtypes in tblRecord where DeptName=frmNew_Record.Department.values
I really need some help.

bobbilockie is offline   Reply With Quote
Old 11-03-2013, 06:56 PM   #2
Wino Moderator
pbaldy's Avatar
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,312
Thanks: 13
Thanked 4,114 Times in 4,046 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Form on click event coding

Is this what you're after?

Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote

coding , event , filter , form

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
On Click Event on My Form shamas21 Modules & VBA 3 07-28-2009 01:12 PM
Open Form from On Click event to add new record CliffACS Forms 4 07-27-2009 06:28 AM
How to open a form from a double-click event M0E-lnx Forms 4 09-09-2008 02:25 PM
Form's Error Event takes precedence before Click event for Undo button Banana Forms 7 09-04-2008 04:15 PM
Form Button with On Click Event OpenQuery penwood Forms 1 09-19-2007 10:39 PM

All times are GMT -8. The time now is 06:56 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World