Using a macro to filter...

[Randix]

1. I have a form and if you click on one button on the form it runs a macro that opens up another form and the macro has the following condition: [contract]![Project_Name]<>""

2. When the other form is opened, it does it on a query that contains the following code:

SELECT contract.*,audit.* FROM contract INNER JOIN audit ON contract.x=audit.x;

The purpose is to run the second form using two joined tables, but only showing data where one particular field is not null.

It works fine, and in fact initially the filter shows that it contains the correct number of records, eg 1 of 3, however, if you keep doing page down, you will end up with a blank record, eg the filter shows 3 records, but if you keep page downing, you will get to a 4th record which is blank, and then it shows 1 of 4, and then it won't go any further, thank gosh

any idea how to prevent that extra blank record from showing????

 

[Rich]

Set form's allow additions property to no.

 

[Randix]

Rich...thank you for your response...I did set it to "no" and it's still displaying the blank record when you keep paging down...would there be another setting that would supercede the form setting, or would it have anything to do with the fact that i have two tables joined in this form?

Ok, in playing around I tried changing the property in the macro that calls the form, and when i change the setting there to read only, the blank record does not show up in the form...however, i want the user to be able to edit the records, just not add...the settings on the form itself seem to have no impact

[This message has been edited by Randix (edited 03-24-2001).]