Solved Small issue to get the field value using VBA

[rehanemis]

Hi, I am wondering about a small issue which I am facing to get the ID from a table using Function call. It is working perfectly on my other MS Access program but not on the currently attached. If you open frm_Customers and hit show button you will see it giving error Object required.

Can any one troubleshoot and share what is the issue?

Thanks!

 

[June7]

There is no object named txtCID.

Did you debug?

Why using unbound form?

 

[rehanemis]

I would like to learn about how to deal using unbound and all to deal using vba.
I have made field txtCID and it showing the results.

 

[rehanemis]

any suggestion from your side as i would like to design POS retail system.
so approach is good as I also want to learn.

 

[The_Doc_Man]

The forum has a decent SEARCH ability so try searching for "POS" or "point of sale" within the forum. I recall some threads on the subject but not recently.

 

[Mike Krailo]

Does your other working application connect to SQL Server? Because it looks like that function takes a ADODB type of connection. In this example, you are trying to use it on a local table.

 

[SHANEMAC51]

If you open frm_Customers and hit show button you will see it giving error Object required.

Public Sub Reset()
Dim txtCID As Variant
'txtCID.Value
txtCID = AutoNumberReturn("tbl_Customer", "CID")
Me.CustomerID.Value = AutoNumberReturn("tbl_Customer", "CID")
MsgBox Me.CustomerID.Value & " or  " & txtCID


End Sub