I want to be able to do the following: type a new entry into a datasheet column, which brings up a form when that enty is not found by using the "Not in list" event. On closing that form I need some code that renames the entry I have just types to, say, "Name". Is there a way to write code that clears/renames the contents of one cell of a datasheet?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Renaming datasheet entry using VB code
- Thread starter cpc34
- Start date
Hi
If you search the FAQs for Not In List, you will find quite a lot of information. However, it sound like you might be using Lookup Fields. This usually comes with a warning, which you will find here:
DHookom: Did you use the dreaded anti-feature of Lookup Fields in tables?
Apologies if I have missed your point.
If you search the FAQs for Not In List, you will find quite a lot of information. However, it sound like you might be using Lookup Fields. This usually comes with a warning, which you will find here:
DHookom: Did you use the dreaded anti-feature of Lookup Fields in tables?
Apologies if I have missed your point.
- Status
Similar threads
