How to attach Combobox two an unbound form

[carletto]

I have form that has on calendar control that i select the date for two text box that are the start date and end date, the two text boxes (start and end date) are connected to the queries buy a parameter in the Date fields:

Between [Forms]![frmOrderByCustomer]![txtBeginDate] And [Forms]![frmOrderByCustomer]![txtEndDate]

But I have also to filter the data by Customer, I have added the combo box with the customr name and ID, I have tried to attach another parameter to the query in the CustomerID ([Forms]![frmOrderListing]![comCustomerDetails]) but I am not able to make it work.

How can I make it work?


All of this is to retrive a data in a report.

Many Thanks

 

[RainLover]

If you have more than one Column in the Combo Box then you may be getting data from the wrong Column. Make sure ID is in the first Column and that it is also the bound Column.

Set the width of your first Column to 0 and the second to 1.

 

[carletto]

If I put first column o and second to 1, I can only see the customer name but it give me error that I should put a number there...

what do you mean? Make sure ID is in the first Column and that it is also the bound Column.

I am not able to make it work.

my form has not data in the form is made to filter a report by date (from and to with to text box connect to a calendar contraol) and after I would ike to filter them by customer as well from the combo box.

I can do it not from the combo but from the query if I put [Enter CustomerID]

when I put the date from and to and I preview the report it gives me a parameter to insert a customer id, I insert the CustomerID and I get a correct report, but this is not a nice way to do it, is not it.

Hope you can give me a right hints

 

[RainLover]

Please post a copy of your database.

 

[carletto]

Hi

I have attached the database, this databse is working with back end and front end databse.

You should opne the jmaur03_d3fmaFE that FE is for front end.

the form I am inquiring about is the form OrderByCustomer....


Many thanks

 

[RainLover]

Nothing attached.

Please try again and test.

 

[carletto]

the forum limites is 750 my database is bigger 1.25

I can not send you my database through the forum

my e.mail is cmaurello@hotmail.co.uk if you can send me an e-mail and I can forward you my databse

 

[RainLover]

You need to compact and zip.

Tyr again.

 

[carletto]

The database is ziped because it is unziped size is 3.33 MB

 

[carletto]

It is still big even I compress it first and ziping it 833 kb

 

[carletto]

I canceled few form to get to this size.

I have attached both database back end and front end

 

[RainLover]

OK

I got that. I enter the details in the Form Order By Customers. What do I do now.

 

[carletto]

if you put the start date and end date and you press preview you get a report with all customers in that period of time.

I need to filter thereport for one single customer choosing the customer from the combo box customer details.

the combo box is not attched to anything

 

[RainLover]

I gave you the correct answer in post # 2.

I have done it properly for you in the attached.

Look at the properties of the Combo box.

I cut the database down so save space.