Search results

That did it!!!! Thank you so much - I've been trying to get that to work for a week!!

It is a text field - our field staff often use letters in the Space IDs...so that gave me a syntax error...could you give the syntax for text? Thank you so much!

Re: Copying records with new ID That's right - I want it to prompt to enter the space to copy from, append the flooring from that space (all HomoIDs for flooring) but capture the new space ID to use for the appended records. Does that make sense? The code I posted does append the flooring from...

I have a form with several subforms for entering information while surveying rooms in a building. I am trying to create a button to copy records from one of the subforms if the data is the same (for example if there are 3 types of flooring in multiple rooms) and append it into the same subform...