Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-24-2011, 01:26 AM   #1
jonathanchye
Newly Registered User
 
Join Date: Mar 2011
Posts: 448
Thanks: 27
Thanked 19 Times in 15 Posts
jonathanchye is on a distinguished road
Remembering value entered

I currently have a lot of textboxes in my form for users to key in values. I realised that some values might be the same for new forms so I have two questions :

1) Is using a combobox the only way to autofill values based on what users previously typed? Can this be done in a textbox as well? Asking this because too many comboboxes in the form won't look nice

2) If the unique ID of the field is a number and I create a new enquiry is there a possible way to search through the table and autofil all fields last entered releavant to the customer combobox regardless of unique ID?

For example ID1 is filled in with details relevant to ACME, ID2 is to BESTCO, ID3 ACME again, ID4 is NEWCO and now I create a new form ID5. When I select the customer combobox as ACME can I autofill the rest of the fields relevant to information I've filled in ID3?

I think basically I am looking for an improved Duplicate Record function where user can select which record to Duplicate and maybe which fields?

jonathanchye is offline   Reply With Quote
Old 03-24-2011, 02:40 AM   #2
JamesMcS
Keyboard-Chair Interface
 
JamesMcS's Avatar
 
Join Date: Sep 2009
Location: Northamptonshire, UK
Posts: 1,819
Thanks: 14
Thanked 47 Times in 46 Posts
JamesMcS will become famous soon enough
Re: Remembering value entered

1. Not at all - in fact I think the best way to do this is to store the values from the text boxes you want in variables which are then used to repopulate the text boxes when you move to a new record.

2. Not clear on what you mean here. You want to be able to search for the latest data related to a customer when you select their unique ID in a combo box? That's possible too - you'd have to create a query to pull back the fields you want, with the Max of customertable.recordnumber where customer ID is the value in the combo box. Easier than it sounds written down
__________________
Cheers

James
If someone's helped you out, don't forget to click on the scales icon in one of their posts and add to their rep.
JamesMcS is offline   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
Remembering Values spectrolab Modules & VBA 5 04-15-2010 10:13 AM
Help remembering variable outside If statement fredalina Modules & VBA 5 12-17-2008 02:33 PM
Dlookup remembering... Em272 Modules & VBA 6 01-19-2008 04:23 AM
Remembering Entries on a Pop-Up Form jalge Forms 1 04-15-2003 08:16 AM
Remembering a record for navigation? EARTHWALKER Forms 11 05-09-2002 04:54 PM




All times are GMT -8. The time now is 07:32 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