Update Unbound TextBox

[*Pete*]

Hello,

I'm having a problem with one of my forms, i have created an unbound text box called Hours. In it i will type a number. Then click on a button to create a report based on this number.

what is happening though is that when i click the report button the report is blank, if i close the report and then click the button again i get the expected results. What seems to happening is that after i click the button the first time the form refreshes itself and the number is picked up.

Is there any snippit of code i could add to the print report button so it will work first time?

regards

Pete

 

[ansentry]

What does the number that you insert into the unbound text box represent?

Also if you enter data into an unbound text box, close the form the data is gone.

 

[*Pete*]

Sorry the Field is linked to a query, so the number i type in the unbound box is for that query. Parameter is : Forms!F_InputHours!Hours


I dont want it to save the record as the number changes depending on what i'm looking for.

 

[ansentry]

Here is a sample for you. I would use the combo box method because as you add hours to the table they automatically appear in the combo. With you method you may type 10 different hours and they may not be in the table.

However it is your database so you make the choice.

 

[*Pete*]

Thank you, I did not think about doing that.

Kind Regards

Pete