not understanding

[Mattymatt79]

Ok,
I have a form based off of a query pretty simple huh?
well how do I get it so when it opens the form that its already set at add a new document

or how do I get it to make it show an already sorted view?
IE like I have my query to sort via date desending but the form wont open that way?

 

[wh00t]

I have a form based off of a query pretty simple huh?
well how do I get it so when it opens the form that its already set at add a new document

In the form properties, data tab, set Data Entry to Yes

or how do I get it to make it show an already sorted view?
IE like I have my query to sort via date desending but the form wont open that way?

In the form properties, data tab, set the Order By to the field you wish it to sort by.

 

[Mattymatt79]

also is there a way to make it not show things after a certain date?

this is what happens when you dont work with access for 6 months

 

[Mattymatt79]

Thanks
I havent used access at all in months and im forgetting how to do even the most easiest things

 

[wh00t]

also is there a way to make it not show things after a certain date?

set this in the criteria of the query

 

[Mattymatt79]

got ya
really what my question is

we have a tracking system that the people that I work with want to display

I have it as a table
and then I have a form to enter data in it.

they send things in to us we respond to it and it has certin dates on it

what I mean is like say something is due on the 26th of this month like after the 26th anything due prior to it is gone

but obviously things due the 27th and beyond would still be displayed

so is it like something like >current date = visible or something?

 

[wh00t]

if the form is based on a query, set the following criteria for the date field

>Date()-1

 

[Mattymatt79]

uh where?
the date is entered in by them

a date recieved
a date due
and date sent

where would I put that

>Date()-1 at

 

[Mattymatt79]

Im an idiot
figured it out on my own
thanks for all the help though