Sounds more like it... btw it's faster to run it once with embeded replaces, makes less work for the server.

What are you having problems with?

Not the right person asking .

HTH.

Does the update work in QA?

I never tried to do it on the click... maybe there's an exec time limit on that event (if such a thing exists). However in this case you have...

Me!cboStudentSurname.RowSource = "Exec dbo.sp_lststudent_surname '" & Forms!frmacyear!AcYear & "', '" & "letter" & "'"

btw don't use sp_ as a predixe, the server will go look into master first instead of...

Create trigger tr_name on tableName

for insert, update

as

set nocount on

insert into table2 (col1, col2, col3, col4) select col1, col2, col3, col4 from inserted where col4 = 1

delete from table1 where col4=1

go

Check with the profiler to be sure... but it should fetch the data on a need to show basis (for the subform).

This seems to be an access bug but caused by a design error. You should never load 10K students in a list. You should have the users enter...

Are you sure this works?? I never heard of replace doing more than one s/r at once.

I was reffering to this quote "However, nowadays RDBMS is equal to DBMS to most non-techs...."

not you .

Sorry, no clue in that case.

update tablename set phonenumber = replace(replace(phonenumber, '(', ''), ')', '')

How do you do that?