Search results
-
M
SQL in a form
its probably because you told the form ... (through the list box's data properties in design mode ) ... that the list box would be recieveing a RowSourceType of "Table/Query" and didnt specify what the RowSource query was (in your case it should have been "Query1") and while initialising... -
M
SQL in a form
im a bit confused but i got rid of your error, im not sure its what you want tho.... go into design mode of frmSearch rightclick on the listbox and select properties click on the data tab set the rowsource property to Query1 does this work? -
M
Form Filter Problem
hmmm... you got me thinking now.... do you mean.,... i could set form 2's filter and serverfilter to "" on form 1 where i call form 2 using the docmd.openform function??? might actually work that! il give it a shot... thanks, i wont know until another user manages to make it fall flat on its... -
M
SQL in a form
where do you set the record source for the search form???? i cant find it!! -
M
Form Filter Problem
Tools: Access 2000 VBA SQL Server 2000 ------------------------------------- Problem: I Have 2 forms (form1 and form2). Form 1 calls form 2.... Now at the start form 2's "filter" and "server filter" properties are empty. I have 2 questions.... what do the filter and server filter do?? why...