Where condition on macro

[hunterfan48]

When you open a macro, on the bottom of the page there are six different action arguments that I see.

The one I have a question about is the 'Where Condition'

In the Northwind 2007 sample database, it reads

1=0

Does this simply mean that since 1 will never equal 0, it will not match any records on this form?

Thanks,

 

[pbaldy]

Haven't seen that done that way, but yes, that's exactly what it would do. What are they doing with the form?

 

[spikepl]

The condition 1=0 can be used to open a record set aimed at adding data to tables already containing data without dragging all the preexisting data into the record set. Eg for adding a new order or orderdetails.

 

[pbaldy]

The condition 1=0 can be used to open a record set aimed at adding data to tables already containing data without dragging all the preexisting data into the record set. Eg for adding a new order or orderdetails.

True, and I do that often with recordsets, but I don't see the point as a where condition opening a form. You could simply use data entry mode.

 

[hunterfan48]

The condition 1=0 can be used to open a record set aimed at adding data to tables already containing data without dragging all the preexisting data into the record set. Eg for adding a new order or orderdetails.

This is exactly what they are trying to do on this sample form, which I have now incorporated into my database.

In reference to your question PBaldy, I did have my form originally set up as a data entry form. This worked fine for entering a new order because it wouldn't bring in the previous records that I didn't care about.

However, I also wanted to use this form as a way to view details about previous records. So, looking at the sample Northwind Database, I found out that the forms I was trying to base mine off of were not data entry forms because I was still able to view previous records.

Thanks for all the replies and help!

 

[pbaldy]

I use a sinle form for both too, but I've never used that technique. I just use different arguments of OpenForm. That said, I don't see anything wrong with this method.