Data entered in form shows up on other forms = no good

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with one main table and several forms generated from
different queries. The data being entered are different types of accounting
adjustments: checks/wires, write offs, money movement between accounts, etc.
All records are stored in one table, called "Adjustment Table", but each
different type of adjustment is entered through a different form.

I have a version of this database where each field on each form is
different; i.e. there are 8 different fields for "Date Processed", 8
different fields for "Amount", etc. I am trying to simplify all of these so
only one "Date Processed" field is necessary. However, when I do this and
then enter information into one form, that record is viewable on every form;
if I enter a check in the "checks" form, it is viewable in the "write offs"
form as well. In the old version, if I enter a record in the "Checks" form,
it is only viewable from that form (if you click datasheet view or if you
scroll through the records individually). I realize this is mostly because
most of the fields are different for each form.

Is there a way to make 8 different forms, based on 8 different queries,
using many of the same fields in each (date, authorized by, department,
amount, etc) and make it so if I open the "Adjustment Table" I can see every
record entered but when I open a specific form, I can only see the items
entered via that form?
 
Hi,


Add an extra field, in the table, that specifies the "form" to be used to
display it. Next, in the forms, filter on the data to only see those rows
having the acceptable value (or better than filter, use a query with the
appropriate criteria, different, that is, for each form).



Amount, otherField, Department
45, ..., "form1"
54, ..., "form1"
11, ..., "form2"



In this case, the first two rows are only available from form1.


Sure, each form have also a hidden control bound to the extra field, here
Department, and always pushed the correct value in the Before Update event
of the form. So, form1 will do:

Me.Department= "form1"


(assuming the hidden control is Department) in its FORM before update event.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top