J
john
I have to find a way to create real-time Confirmation # from information that
is optained from a form. I created a Unbound Text box which does what I
want; Code, = left([Stat lab],2)& right(Year(Date()) which gives me a value
of XX09 from the currently entered information.
Now that I have this I need to have the text created (XX09) to be saved with
the current form. How do I do this??
Like I mentioned this is an Unbound Test Box which I would like to link or
save within the same table which the form was created from. Do I need to
make it a Bound Test Box?? How do I do that?? Everytime I do that it asks
me which forum or query do I want to use.
I tried to use a query when creating the form but the coding I put into the
query keeps stating I have an error with the code; mainly the Left function.
Thanks
John
is optained from a form. I created a Unbound Text box which does what I
want; Code, = left([Stat lab],2)& right(Year(Date()) which gives me a value
of XX09 from the currently entered information.
Now that I have this I need to have the text created (XX09) to be saved with
the current form. How do I do this??
Like I mentioned this is an Unbound Test Box which I would like to link or
save within the same table which the form was created from. Do I need to
make it a Bound Test Box?? How do I do that?? Everytime I do that it asks
me which forum or query do I want to use.
I tried to use a query when creating the form but the coding I put into the
query keeps stating I have an error with the code; mainly the Left function.
Thanks
John