Khalid- That compiles and will work, but it won't do anything with CollectionCode. Needs one more line: Private Sub ConsignmentNo_AfterUpdate() Dim strCode Asjlviescas
Khalid- Try this: Private Sub ConsignmentNo_AfterUpdate() Dim strCode As String ' Define string to generate a random letter Dim strAlpha As String Dim intI Asjlviescas
John, After running the new form "Assign clients to Consignment" and running the code you gave on the after update event of ConsignmentNo following errorkhalidtanweerburrah
Please Note: New Members will have their posts moderated for a period of time so we can be sure you are a real member and not a spammer. Sorry for the inconvenience.
Please Note: We do not allow job postings or recruiting at this site. Doing so will only get you banned.
Whether you are seeking help in database design, user interface, complex MS Access VBA code, MS SQL Server, we can help.
Our membership includes several MS Access MVPs and questions are answered quickly and accurately! Our Archive contains many sample databases, Utilities, Add-ins, code samples and more.
Share your knowledge and it will come back to you ten-fold!
For more accurate answers, please indicate which software version you are using when asking a question.
- Microsoft Access
- Mar 28, 2002
- This is a restricted group.
- Attachments are not permitted.
- Members can hide email address.
- Listed in Yahoo Groups directory.
- Membership requires approval.
- Messages from new members require approval.
- All members can post messages.