help with form data synchronising required

  • Thread starter Thread starter Norman Fritag
  • Start date Start date
N

Norman Fritag

Hi there

I have a form wish is used to doubt check data been entered before it is
updated to the main table.
I structured the form into 3 tabs of which the first on represents the total
amount entered by date.
the second tab represents the total amounts by date and Area
the 3rd tab represents the amounts entered by date, by area, Product (detail
section)

Now I like the person checking if the entries are correct to start at the
first tab.
When staff enters the curser into any date field of the first tab (data
source is a subform), I like to synchronise / link alien the data and
contents of tab 2,3 to reflect only data entries of the date selected ( in
first tab).

The same is achieve by making the data of the first tab the source of the
main form, then use a drop down listbox to find a record in the form. If I
have the data in tab 2,3 (as subform linked on date = date), then data will
change after the afterupdate event of the dropdown listbox is completed, to
link on the date selected.

Amy ideas?
Which event I would could use? or what structure the form requires?

Kind regards

Norman
 
Norman

I've read you're not about 3-times, and I'm still not certain I understand what you're doing. At least not enough to give you any advice. You've got 3-tabs (I get that) a subform as the data source (you lost me) something about an alien (a typo?) and wanting to only display data with the date of the first tab (I get that). My suggestion, clean-up you're message and repost it

In general, I assume you've got a query that you use to generate data for the form.You're then filtering the form by date to display the values you want. On the 2nd and 3rd tabs you've got controls for each piece of information you're displaying. My question is can they edit that data or simply view it. If they should only view it, I would do so through a list box. If they need to edit it, consider a list box that drills down to a detail screen through a double-click even on the list box. Depending on how much data you're pipping into the form you're performance will suffer significantly the larger the recordset grows - my approach will mitigate the performance hit. Try refreshing at the point when the user changes from one tab to the next - see OnChange() event for the tab control. In my experience multiple subforms with tabs seems like a good idea, but it isn't. Ditch the subforms

Regards
Adam
 
Back
Top