Separate Active & In Active Account Numbers in to Text Box

[Only4Access]

Thank you June7.



Sorry, how can I change aryNums source to a table instead of Text box? If account numbers are getting through a table (tblNewAcc[Accounts]) instead of text box.

Steve,

Thank you for the file. Will check it out.

[June7]

How does the data get into the table? I thought you are copy/pasting into an unbound textbox?

The array code won't go away if the data is still a multi-line string.

[Only4Access]

Initially they will copy & paste account numbers in Text box, then after will open tblTemp form for further filling information. When click on a button from this form, need to check above conditions. This is a regular table NO multi line in a row.

So, i like to revise aryNum source form Text1 to tblTemp[Accounts]

If i simply set

aryNums = tblTemp[Accounts]
For i = 0 To Unbound(aryNums)

will this work?

Thank you June7 for your continuous support.

[June7]

No. Now the code will loop through records of the form or a recordset object and the array goes away.

[Only4Access]

June7, how can I revise that VBA?

[June7]

Here is information about working with recordset objects.

http://www.everythingaccess.com/tuto...ith-Recordsets
http://allenbrowne.com/ser-29.html
http://msdn.microsoft.com/en-us/libr.../ff820966.aspx

Also, RecoredsetClone can be quite useful.
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

[Only4Access]

Thank you June7