Date in a Form and a Table

[CHOO]

Hi,



How do i get just one date in a table? At the moment, when I open the form input the information with the same 2 dates eg: 16/05/2014 and 16/05/2014, these 2 dates will appear in the table in seperate rows. How do I get it so if I put in one date I can append to that date multiple time instead of creating the same date within the table. Thanks.

[ranman256]

Do you mean 2 dates in 1 field, or 2 dates as 2 different records, or 2 fields each with 1 date?
If you have 2 dates in 1 field, then the field is set to the wrong data type.

[Missinglinq]

Like ranman256, I'm not really clear as to what you're asking, but if you're saying that you want to enter a date into one Record, then have it to appear in subsequent Records, you can dynamically set the Default Value of the Control to that initial date, using its AfterUpdate. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each New Record.

Private Sub YourControlName_AfterUpdate()
   Me.YourControlName.DefaultValue = """" & Me.YourControlName.Value & """"
End Sub

This syntax is valid for Text, Number, DateTime and Boolean Datatypes.

Linq ;0)>