update table from form

[tiggy]

I sent Milo-Phile a private message regarding an example db that was posted regarding updating a table 'on the fly'. The example had one box updating a table from a form (to see the example db in 'search' type not+in+list).

I have a form for which I wanted to update several fields and with which I was having problems. Milo quite correctly pointed out that I should continue this on the open forums as it could be of benifit to many rather than just to me.

One of my problems was that the code was referencing a Library object that was not open in my db.

Thats the background and this is my next problem.

I have no modules in my db, so I copied a global one from the ms contacts db, and changed the reference as suggested. I think my problem is now in the syntax as I do not know how to seperate each field I tried using an & between each field but that was no good, and then I t ried without anything, again no go, how would you seperate these please?

.Fields("shipper")("address")("country")("contact")("telephone) = StrConv(NewData, vbProperCase)

Thanks

Tig

 

[Mile-O]

.Fields("shipper") = shipper textbox
.Fields("address") = address textbox
.Fields("country") = country textbox
.Fields("contact") = contact textbox
.Fields("telephone) =contact telephone

You need to do one line for each field you are updating.


You can also delete the module. You only need to use a module (forms have modules too) to get to the references menu.