PDA

View Full Version : Data Entry/browse


ABC123

scottly
11-10-2003, 04:22 AM
I am trying to develop a Form (modeless)that maintains data in a table (no set involoved). Common to each record in the table is the Date (and date is a non-unique index).

I want the date field to be entered first and then the user can enter multiple records for the entered date in an embedded browse.

Where records exist for a date, after the user enters the required date the browse should show only records for that date and also allow changes to those records or entry of new records. Where records do not exist for a date, the user can go ahead and enter new records for the entered date.

I have tried running a custom query 'onchange' on the date field that filters for records for the entered date, but this does not seem to work.

Can anyone get me started on successfully developing this common type of data entry program? The issue is, how do I get the browse to filter for the date that is entered on the Form, and then also save any new records entered into the browse with that date.

Regards,
Scott

scottly
11-10-2003, 12:12 PM
oops - wrong forum..