Search results

Aah, got it. That did it.

Just trying this out and it works when just displaying the value. If I try and change the form to save the value then I get the error Cannot find the object me. and the value does not display in the text box, presumably as it no longer has the same instructions in the control source.

Thanks that's really helpful as well. The animal information is only a small part of the data so doing it this way I would need a sub-form to allow me to use the query as the data source? If the information wasn't saved then it would change the way I report I suppose. For example, at the...

OK, I see how that works. Things would change, latin names get modified over time, species change CITES appendix and so on. I'm not sure that matters though as you would probably want to see how things are classified now, not what they were when the animal first arrived. Probably I don't need...

Possibly, once I have digested it. If I understand this then you basically call a combo box but don't display all the data, and then have a text box with a control that gets the relevant hidden field. Is that correct? I don't quite understand the bit about saving the data, which I will need to...

I am sure that this is a simple problem to anyone with some experience but it has got me stumped. I have 2 tables "Animal_Data" and "Species_Data". Animal_Data has fields: "TxtCommonNameOnAnimalData", TxtLatinName, TxtCITESStatus and TxtAnimalClass. The information to fill these fields is...

Hi, complete beginner here on a vertical learning curve. I foolishly agreed to write a database for an animal charity to record the animals coming through their rescue center, very simple one but its all new to me so apologies for the basic questions.