on the after update event of the employee id field, you could put something like:

Me.EmpName.Requery

to force it to refresh.

Dick

If you go with the TransferText option, there is no way to stop it from reading all fields and all records.  So you could put it into a temporary table...

Sorry for the omission.  I'm in Connecticut, and my clients are primarily in CT and surrounding states.

I'm thinking that the problem may involve finding the correct name for the SQL Server instance.  It would make it easier to troubleshoot if you can install the SQL Server...

I guess you are saying that you can't switch to an Access .adp, which would give you the ability to set up the subreports using stored procedures driven by a...

As Luke said, I would ask for some guidance from your ISP.  Many do not allow direct access to the SQL Server, but I would think that if you had...

This process could be automated with some programming.  I don't think the above approach would be enough if your database involves related tables, autonumber fields, etc.  And the upsizing wizard...

I've been a proponent of using ADP's for Access applications involving a SQL Server database, and would be interested in some links to the anti-ADP "rumblings" you mention, since I...

Did you make sure that when you split the database all the temporary tables were in the front end rather than the back end (where data would normally be)?

Dick

It seems to me it makes a difference whether you will always only be using these 10 tables, or would eventually like to use all of them.  Relinking 400+ tables takes...

I think you need to find a new programmer.  First of all, there is no reason why the tables should need to be relinked every time.  And if you used...

I would think it might be a better idea to create a stored procedure to truncate, and give the operator execute permission on the SP.

Dick

Whether you are working with an mdb or adp, I believe the most efficient means of doing this would be having some extra columns (possibly hidden, ie width=0) in the combo box. ...

There are some differences, though.  I found, for example, that in a report =Sum([a]+) will work fine with an Access back end, but that you need to use =Sum([a])+Sum() in an...

If you have trouble getting the report formatted the way you want, I've sometimes had better luck by setting up some extra grouping fields, so that I can put each...