List for data entry

[DBL]

I've got two tables, Properties and Valuations. Every six months the properties are revalued. I want to have a datasheet list of all the properties with a blank field for the new valuation so that the user can just go down the list and enter the new amount without having to select every property individually. Can I do this?

 

[FoFa]

OK, Maybe I misunderstand, but if you have a datasheet view, is not what your asking basically what you have?

 

[DBL]

I didn't think I'd explained it very well! I have my properties table linked to my valuations table by property ID. If I create a query I get:

Property Valuation Date of Valuation
Address 1 £350,000 30/10/04
Address 1 £365,000 30/04/05
Address 2 £240,000 30/10/04
Address 2 £260,000 30/04/05

When it comes to putting in the next valuation in six months time I want a form that lists all the properties, without the previous valuations, but ready for the user just to type the new valuation and date in beside the relevant property.

Property Valuation Date of Valuation
Address 1
Address 2

At the moment the only way I can think to do it is with a main form with the property details and a sub form with the valuation details but it's too time consuming for the user to select each property individually to put in the current valuation when they've got 30 valuations to enter in one go. It would be much better to have a list of the properties ready to take the next valuation.

Hope that's a little clearer!

 

[FoFa]

Well, you can do this using a form, but you have to display the property information outside of the underlying table for the form (Valuations).
This would take some coding to handle. This is basically a main/subform type application. On the other hand you could handle this with an unbound form, and display the property information, and when a valuation is entered, pull that property information (key from the form) and update the table with VBA (your best bet at this point). There maybe another solution that I am just unaware of, maybe some one else has a solution also.

 

[DaveJHPT]

It strikes me you'd have to enter a record for each property as at the new valuation date first (through code or a query).

Once you're there, you can then filter to just those records and add the valuations through the datasheet view of a query, or (bettter) a form.

Dave

 

[DBL]

Okay, I can see an unbound form working, with the valuations table updating through an Append Query at the very least. If I've been able to list all the properties and then have an unbound field to take the new valuation, in datasheet view, but when I enter the value it fills in for all the properties! I know this is probably very simple but it's got me stumped, if anyone could give me a bit more info I'd be grateful.

How about if I used a multi-list select box where the user could select the properties with the new valuations (as they might not all be valued at the same time) and then append those records to the valuations table, and then list them in another form ready for the values to be put in?

Thanks