Null Value is Textbox

[Jonno]

I wish to update a Textbox to "Null" using a combo box. I will explain.....

I have a form with a listbox based on a query. The Criteria for the query are textboxes on this form. for example, the user selects values Open or Closed from a combo box. Textbox named"Status"
is updated to value as chosen. The listbox is then requeried to show only open orders. This works fine, but what I want to have is the Open & Closed option, so when chosen from the combo list, "Status" = "is not null" and when the list is requeried both open and closed orders are shown.

In other words, using VB how can make me!status = null value which will work in the query grid.

I hope I haven't make this sound incredibly confusing!

 

[namliam]

You have given the answer to your own question...

Regards

 

[Jonno]

The trouble I have is that the Query only recognises the content of the textbox as a Text value, so Is not Null = "Is not Null" in the query grid and therefore not returning results.

 

[namliam]

Try querying for like"*" that should return all Not Null values...

Regards

 

[Jonno]

The thing is, what I want to appear in the Query grid is variable according to data on the form.

Maybe a better way of explaining is to look at a similar function on internet sites which I want to recreate. for instance if you go to a property search Website, you can search for properties and set criteria for your search, say view only flats, or view both houses and flats from the website.

I have tried it a different way using a continuous form and having a filter applied, but still still banging my head against the office wall trying to suss a way of doing this!

 

[namliam]

Post a sample of what you are trying to achieve.....

I am sure someone can figure it for you...

Regards

 

[Jonno]

Hi namliam

I will put together a little example....

 

[Jonno]

I have attached a very simple example of what I am trying to achieve........

 

[Rich]

You can't view anything listed as house and flat because there is nothing in your table defined as house and flat

 

[namliam]

You can't view anything listed as house and flat because there is nothing in your table defined as house and flat

He (she?) means it as a kind off 'ALL' option....

Jonno,

Try attached sample and see if it suites your needs....

Regards

The Mailman

 

[Jonno]

Brilliant! simple solution - feel silly now, thanks for your time!