I was hoping to get some help with the following code. I have a field that I need to populate with the result of a sql select statement. Cant seem to work
So when I click a button I need the field to be populated with the max of a value
Me.provid = DoCmd.RunSQL "select max(id) from ser_faxes_file"
somehow it cant seem to work. I was reading a bit and noticed that docmd.runsql is not used for select statements. Not sure what to use.