UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Simple Syntax Question    
 
   
Mink
post Jan 5 2005, 09:41 AM
Post #1

UtterAccess Veteran
Posts: 430
Below is a code that I want to use to pass the values of two boxes into one box on a new form. I know my syntax is bad so the command will not work, but can you please suggest the correct syntax?

I am getting with this code a "You can't assign a value to this object" error.

[Forms]![frmEngineerECN]![ReleaseDate] = Me.cboYear & "-" & Me.txtECN

Thanks in advance!
Mink
Go to the top of the page
 
+
MattJ
post Jan 5 2005, 09:48 AM
Post #2

UtterAccess VIP
Posts: 4,621
From: North Carolina, USA
The following worked for me:

Dim strYear as String
Dim strECN as String
strYear = Me.cboYear
strECN = Me.txtECN

[Forms]![frmEngineerECN]![ReleaseDate] = strYear & "-" & strECN

HTH
Matt
Go to the top of the page
 
+
Mink
post Jan 5 2005, 10:10 AM
Post #3

UtterAccess Veteran
Posts: 430
Thank you very much! After finding out that I also had the code on the wrong event I got rid of the other error as well.
Go to the top of the page
 
+
MattJ
post Jan 5 2005, 10:36 AM
Post #4

UtterAccess VIP
Posts: 4,621
From: North Carolina, USA
Your welcome!
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 02:23 PM