Sabtu, 10 September 2011

RE: [MS_AccessPros] Setting default values for a new record

"customer name and address and customer vehicle make, model and year" should only be stored in one place in your application. You can use various methods to display this information in other areas. I typically use combo boxes with multiple hidden columns. When I select a value in the combo box, the other columns are displayed in text boxes with control sources like:
=cboCustomer.Column(3)
It's all about the combo box row sources, columns numbered beginning with 0, and displaying the columns in other controls.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: drtolson@verizon.net
Date: Sat, 10 Sep 2011 12:26:05 +0000
Subject: [MS_AccessPros] Setting default values for a new record


Great Day, I am creating a job order for an automotive repair shop. When I open an estimate to review it, all of the data has populated the form properly; however, when I create a new estimate, customer name and address and customer vehicle make, model and year, I expected to automatically populate the appropriate fields, but they did not.

Do I need to code the default value for those fields or is there a way for access to automatically do it when a new record is detected?

Thanks in advance,

David


[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Tidak ada komentar:

Posting Komentar