Updating one field to another problem

[amy3000]

I hope I can explain this. I have a table with birthdays of clients. I created a form from this and then there's a subform,from another table, which includes the fields admission and discharge dates (one person can have multiple admissions).

I discovered there is another database I can get those dates from instead of entering all of them. I did an update query to date of birth without any problem.

I tried doing an update query to do the same thing with admission and discharge dates. The table updated fine. However, when I go to complete the form, the admission date doesn't appear. In fact, the date completely disappears from the table too. I may just go back to entering the dates but thought I'd see if I could get some help figuring this out. Thanks.

 

[JeremyNYC]

OK, so concentrate on the part that went wrong. When you did the update that was supposed to include admission dates, did you get any errors? What happens if you try it again trying to update just that field?

Also, _please_ make a backup before doing anything like this, especially if it's at the recommendation of some wacko on the web <g>.

If you try it again and it doesn't work, paste the text from the sql view of your query into a post and someone should be able to figure out what's wrong.

Jeremy =============
Jeremy Wallace

http://www.AlphaBetCityDataworks.com

Designing, Developing, and Deploying Access databases since 1995.

 

[amy3000]

I think this is one of those things I didn't think all the way through. I did make a copy before I started messing around.

The Client Data table has all the clients from this other database. The Admission/Discharge table only has clients who have had data entered into that table. When I updated, I only updated the ones who were already in the Admission/Discharge table. I think I may have to leave this one as it is.