Access Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database listing all of my permits. I am trying to have all my
forms (receipts, interoffice routing sheets) printable from access. My
problem. I have a receipt button on the main form. When you depress it you
have to enter the permit number and then you can enter the payment
information. Then on the receipt I have a print button, again you have to
enter the permit number. Is there any way to have access pull the permit
number you are "on" fill in each form. Right now you have to enter the
permit number 3 times to get the receipt to print. Thanks muchly.
 
yep....assuming you are not closing the form when you open the next one then
you can do it this way: If the first form is named FirstForm and the
textbox for that permit is named PermitTextBox then put the following into
the control of the other forms textboxes:

=[Forms]![FirstForm].[PermitTextBox]

type it in just like you would the wording of label...

then try it by putting a value into the first form (don't close it), open
the next form...and it will re-use that value...
 
Sorry it took so long to try this. I tried putting the =[form].... as
indicated. It did not work (I tried a couple different times just in case I
was doing something wrong). I tried putting it on the button you click.
Then I pulled up the next form that is linked to the first form and put it in
there. Did not work. But I noticed that after I typed in the "command" the
first set of brackets([]) around form disappeared. Why? So it would look
like this on my control (that is if I am putting it in the correct place).

=form![total info by permit number].[Permit #]
[FirstForm] [PermitTextBox]

Help Help.

NetworkTrade said:
yep....assuming you are not closing the form when you open the next one then
you can do it this way: If the first form is named FirstForm and the
textbox for that permit is named PermitTextBox then put the following into
the control of the other forms textboxes:

=[Forms]![FirstForm].[PermitTextBox]

type it in just like you would the wording of label...

then try it by putting a value into the first form (don't close it), open
the next form...and it will re-use that value...
--
NTC


dtjbocala said:
I have a database listing all of my permits. I am trying to have all my
forms (receipts, interoffice routing sheets) printable from access. My
problem. I have a receipt button on the main form. When you depress it you
have to enter the permit number and then you can enter the payment
information. Then on the receipt I have a print button, again you have to
enter the permit number. Is there any way to have access pull the permit
number you are "on" fill in each form. Right now you have to enter the
permit number 3 times to get the receipt to print. Thanks muchly.
Click to expand...
Click to expand...
 
I tried putting the =[form].... as
indicated. It did not work (I tried a couple different times just in case I
was doing something wrong).
Click to expand...

Reread Network Trade's message. He did NOT tell you to put =[Form]. He
told you to put =[Forms].

The letter "s" is significant.

John W. Vinson[MVP]
 
Thank you. After I read your response I noticed I did have a typo on my 2nd
question. I realized I was running the "button" off a query. (this database
is over a year old and just growing). I placed the information in the query
and low and behold it works!!! It is just the most wonderful thing. Thank
you again.

John Vinson said:
I tried putting the =[form].... as
indicated. It did not work (I tried a couple different times just in case I
was doing something wrong).
Click to expand...

Reread Network Trade's message. He did NOT tell you to put =[Form]. He
told you to put =[Forms].

The letter "s" is significant.

John W. Vinson[MVP]
Click to expand...
 
Back
Top