mySQL /VBA

[deesheeha]

hi,

im reading data from a user, using this data to search a database and then outputting the results to a subform which is in dataview format. the problem im having is im adding 3 additional columns to the dataview and although i can add them, i want the user to be able to edit these columns. heres my SQL statement at the moment:

Set rs1 = mysql_select("select DesignCode, Range, '' as StockLevel, '' as `Trigger`, '' as Issue from cslogcalls.designs where Range = '" & range & "';")
Set Forms!frmAddRange!frmSubRange.Form.Recordset = rs1

StockLevel, Trigger and Issue are the three columns that i want the user to be able to edit.
Any help is much appreciated.
Dee

Dee

 

[JerryKlmns]

Editting a calculated field of an sql statement?

 

[deesheeha]

yeah thats what i want to do

 

[JerryKlmns]

And when the user moves to the next/previous record, you through that away, right? Or you need to keep it?

 

[deesheeha]

no, i need to keep it. it gets written to another table.