I need a subform to stick on one record

[blakerrr]

Hi everyone,

I have a form called Master Order with a subform in it called Order Info. The subform has a nested subform in it called Order Details. Master Order cycles through all of the parts in my database. Order Info contains order specific information (order number, employee ordering, date of order, etc. ) and Order Details contains all of the parts in the order (run off a junction table linking it with Order Info via the orderID field).

So here's my situation: When I open Master Order, I have the the Order Info default to add a new record (ie. create a new order). The nested subform is thus empty (no parts have been added yet to the new order) which is good. The user cycles through the parts in the database to add them to the new order (still good). My ONLY problem (so far) is that I need the Order Info subform to stay on the new record (so that the user cannot accidentally select a previous order). I have removed the navigation buttons on the Order Info subform, which helps, but if i select a field in the Order Info subform and scroll with my mouse, I can move to previous records. This is bad!! Is there a way to make the subform 'sticky', and stay on the one record? I apologize for the long winded explaination.

[FishVal]

Hi, blakerrr.

Set form's property "Date Entry" to "Yes".

[blakerrr]

Hi, blakerrr.

Set form's property "Date Entry" to "Yes".

Thanks FishVal!

Now a new challenge. Can I default a field called txtDateOrdrd in the Order Info form to be todays date? This way, when the master form is opened, the Order Info form creates a new order with a new OrderID and has the Ordered Date filled in. I'm currently using this line of code on the Order Info subform's 'On Open' event, but I get an error saying "You can't assign a value to this object".

Me!txtDateOrdrd.Value = Format(Now, "mm/dd/yyyy")

Any ideas?

[FishVal]

Not a challenge at all, blackerrr.
Set control's "Default Value" property to "=Date()". Avoid using Now() as it generate value with hours, min, sec and msec.

[blakerrr]

Not a challenge at all, blackerrr.
Set control's "Default Value" property to "=Date()". Avoid using Now() as it generate value with hours, min, sec and msec.

Great! Thanks FishVal

[FishVal]

Not a problem.
Good luck.