Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data from one Form to another...

Status
Not open for further replies.

soupisgood84

Technical User
Apr 17, 2007
45
US
I have a form that is getting data from another open form. I have set the default value of the second form's textbox to the textbox of the first. That appears to be working the way I want. Although in one textbox I am trying to add an * (the actual character) to the beginning and the end of whatever data I have in the first text box.

Is there a way to do this in the properties of the textbox? Or is it something that needs to be done in VB?

This is what I thought it would look like but it doesn't work.
= "*"=[Forms]![frmDATAentry]![SerialNumer]"*
 
Try this instead...

= "*" & [Forms]![frmDATAentry]![SerialNumer] & "*"

Gary
gwinn7
 
Perfect! Exactly what I needed.
Now that I see what it was...I actually remembered thats what I needed to do!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top