Need help asap with forms

[edsilvers1]

So i have acquired a Access Database from a person who has left my work without her showing me anything about it.

My question is this:


Suppose i have a full database of Work Orders that i am opening and closing in forms and what not. So i want to know if i can have Access automatically generate a new work order with a new "ID" and a new "Due by" date as soon as i close one work order out.

Please let me know if this makes sense and if i can clarify anything!

Thank you in advance from an Access noob!

[June7]

Possibly all you need to do is move to a new record row. Without more details, really can't advise more specific. If you want to provide db for analysis, follow instructions at bottom of my post.

Strongly advise you get an introductory tutorial book and spend a solid week learning Access.

[edsilvers1]

Hi,

I am not sure how to get more specific and i cannot upload the DB.

In my Work orders, i have it set to where i can only look at “Open” work orders. Which is what i want. But when i “Close” that work order, i want it to automatically generate a new line in my table or generate a new form for a “Open” work order. And i want it to automatically generate a date that is 7 days from when the last work order was “Closed”. Does this clarify at all?

Sorry again!

[June7]

Not much. I don't know how you 'Close' a work order. But I suppose somewhere you could run an INSERT action SQL to create new record in table then requery the form.

[edsilvers1]

I have a Status Column in my table where i can label things as “open” or “closed” and i want it to where when i enter a work order from “open” to “close” i want it to auto generate a new line in the table and generate with a new ID and new Date

[June7]

So use a form bound to that table. Use control bound to that field. In its AfterUpdate event something like:

If Me.Status = "Closed" Then
CurrentDb.Execute "INSERT INTO WorkOrders SET DateFieldName = #" & Me.tbxDate + 7 & "#"
Me.Requery
End If