datebox

[fredde]

Hi gents. I´m new to this and trying to create a logbook. Now, trying
to get my date box to (default) display the last saved date from a
table. ie not todays date but whatever was the last entry. In addition
I would like to have a calenderbox on the side to override default date
..

fredde

[w_a_n_n_a_l_l_ -@-_s_b_c_g_l_o_b_a_l._n_e_t]

Re: datebox

If you just want the date:

me.txtLatestDat e = dmax("EntryDate ", "MyLogTable ")

If you're trying to display the last actual entry , use the same trick to
retrieve the maximum primary key value (asuming Autonumber field for your
primary key, then use that value to seek or filter to display the record you
want.

I don't know your forms setup so I don't know which technique applies to
you.