Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-27-2013, 07:03 AM   #1
samjh
Newly Registered User
 
Join Date: Jan 2013
Location: Scotland
Posts: 64
Thanks: 6
Thanked 0 Times in 0 Posts
samjh is on a distinguished road
Auto Populate Specific Data on a Blank Data Entry Form

Hi,

Looking for help again!

I have a form, which has two combo boxes (amongst others) they are provider and provider rates.
These come from two tables, that are linked by ProviderID which is one(tblprovider) to many (tblproviderrates).

If the rate I am looking for doesn't exist I want to be able to open another form to input the new rate, (I have a button that says click here to enter new rate, and a provider rates form opens). When this form opens it should always open on a blank form, however I want to have the ProviderID already specified in that new form, so that all the user has to do is enter the rate. Once I have entered the new rate and closed the form, I want the rate to be shown within the list in the Rates combo box, so I can then select it.

I have tried on the button to open the form, linking the criteria, and if I look at the properties on the provider rate form, it is filtered on the provider, but nothing is appearing in the ProviderID box.

I'm doing something wrong, but not sure what.

Thanks.

samjh is offline   Reply With Quote
Old 01-27-2013, 08:17 AM   #2
bob fitz
AWF VIP
 
Join Date: May 2011
Location: Essex England
Posts: 3,505
Thanks: 50
Thanked 679 Times in 662 Posts
bob fitz has a spectacular aura about bob fitz has a spectacular aura about bob fitz has a spectacular aura about
Re: Auto Populate Specific Data on a Blank Data Entry Form

If you only have one item of data to add, you could use the Not In List event of the combo box.
When the user enters a rate that is not in the list, the code would check with the user that this is to be added to the list (incase it was a typo). The code would then populate the table and the item would be added to the list.
An example of the code required can be see at: http://allenbrowne.com/ser-27.html
__________________
Bob Fitzpatrick
Microsoft Community Contributor Award (2011)
If this helped, please click the scales at the bottom left of this posting.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Many thanks.


I have never failed. I have found a thousand ways that do not work!

Last edited by bob fitz; 01-27-2013 at 08:32 AM.
bob fitz is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Blank form at data entry joce Forms 5 12-01-2011 03:02 AM
blank data entry form abdul Forms 2 04-13-2011 09:50 AM
Using Data Entry Form to Populate Table Poindexter Forms 2 11-14-2008 12:37 PM
Data entry using blank form? andrefrancis Forms 2 04-06-2005 04:57 AM
Auto Populate Data in Fields on a Form mmayhew Forms 3 04-20-2002 02:28 AM




All times are GMT -8. The time now is 03:15 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
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