copy form data to report after change

[Gazza2]

Hope someone can point me in the right direction.

I have a continuous form that has 5 columns of data per line and it also has a 6th column that I can enter data into. What I want to be able to do is if I enter data into the 6th column it will copy that record except the 5th column to a report.

I have tried searching this forum and other but not quite sure of the terminology so not getting good results.

Any help will be much appreciated

Gazza

 

[jdraw]

Sounds a little like a spreadsheet --can you tell us more or even post a few jpgs
a) your tables and relationships
b) your form
c) your report.

 

[Gazza2]

Hi jdraw

I could probably use multiple spreadsheets to do this but it wont be very expandable when I need to add some other features this is why I am trying to use access.

a) at the moment I for this problem I have 2 tables (TblProducts and TblSalePrices)which have based a query on, The first table is a list of items and there prices (plus other fields)with ProductID as the primary key. The second table is a list of set discounted prices for the items in table 1 linked by ProductId.

b) My form (form1)is a continuous form based on the query for the above two tables and lists only the items relating to a bin range entered on another form.

c) same as form but I only want the items to show if I change the salePrice on the form.

so if I have 10 items on form1 and I enter an amount into the SalePrice column for only 4 of the items then I click a button at the bottom of the form and it copies only the items that I have changed the SalePrice on.

Hope that explains it a bit better

Thanks for the help

Gazza