A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Entering an unbound form control value into a new record field.



 
 
Thread Tools Display Modes
  #1  
Old December 8th, 2009, 02:55 PM posted to microsoft.public.access.forms
Ron[_23_]
external usenet poster
 
Posts: 27
Default Entering an unbound form control value into a new record field.

Hello. I hope this (friendly and helpful) group will forgive a very noob
question, but I learned from my (long gone) self-teaching years with foxpro
that a little good advice can save a lot of grief. I've been setting up my
tables for first time Access project (2007 on Vista), and thinking about my
first form. It will have a couple subforms in it, and is intended for
browsing as well as entering a new record. My focus at moment is on a text
box, whose value will be derived (and therefore be unbound) from other bound
controls (an autonumbered integer (the PK), a user entered date and user
chosen value from a combobox). I know how to construct the expression I
want and display it in the control.

My question: What's the proper way (which event code?) to get the derived
value of that unbound text box into the target field when a new record is
entered? Of course, I want to preserve the value of that field when the
user browses existing records, unless the user edits the date or text box
whose values are parsed into the expression, in which case, I'd want the
derived field to change accordingly. (It's intended as a unique catalog
number. Hence the incorporation of the PK.)

Many thanks for any pointer, RonL

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:37 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.