Forms unbouded/bounded

[Luciano]

Hi, I want myAccess-application in multi-user environment ((maximum 3 users) with a splitted database (Front-end/Back-end). Should I use bounded (quit easy) forms (with action-queries and ADO-Recordsets and VBA) or unbbounded forms (rather more complex).

 

[Alansidman]

Cross posting: http://www.accessforums.net/forms/un-bounded-forms-33198.html

Please read: http://www.excelguru.ca/content.php?184

 

[Luciano]

Sorry, I didn't know there was a relation to the other Access Forum.

 

[Alansidman]

There is no relation between the forums. Many folks like you participate in several forums. Please read the link I provided so that you better understand why you need to identify crossposts.


Alan

 

[Luciano]

There is no relation between the forums. Many folks like you participate in several forums. Please read the link I provided so that you better understand why you need to identify crossposts.


Alan

Thanks for the information. Someoneon the forum was very helpfull.

 

[Luciano]

I use and need very often 'Text-fields events' (Got focus/After update).This effects updates in two other tables. Do you mean by 'Form level events' that I rather avoid this Text-fields events (this would be very annoying)?
May-be I will know what's better trying it out wit real data?

 

[gemma-the-husky]

I use and need very often 'Text-fields events' (Got focus/After update).This effects updates in two other tables. Do you mean by 'Form level events' that I rather avoid this Text-fields events (this would be very annoying)?
May-be I will know what's better trying it out wit real data?

why would an event handler for a text field cause an update on 2 OTHEr tables?

 

[Luciano]

The updated text-fields are numeric. Updating such fields in one (table-bounded) form, causes updating (calculated) fields (using the updated text-fields) in other tables.