X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Closed TopicStart new topic
> Run Time Error 2448, Access 2013    
post Feb 25 2018, 12:05 AM

Posts: 9
Joined: 24-February 18

I have a control in a subform that should be calculated in VBA code , it had a (number) data type on the source table and the subform is going on a recordset , it keeps giving me a 2448 run time error and do not calculate ( Me!AB.Form!mark1.Value = b * Me!AB.Form!nom1.Value / c
) the code is as follow
Private Sub Command13_Click()
Dim a As Integer
Dim b As Integer
Dim c As Integer
a = DLast("nom", "main")
b = (100 / a)
Dim DB As DAO.Database
Set DB = CurrentDb
Dim rs1 As Recordset
Set rs1 = DB.OpenRecordset("sub")
Do While rs1.EOF = False
c = DLast("nom1", "sub")
Me!AB.Form!mark1.Value = b * Me!AB.Form!nom1.Value / c
End Sub

Please do NOT cross-post. It does not improve chances of getting an answer and can be confusing.

This post has been edited by GroverParkGeorge: Feb 25 2018, 08:22 AM
Reason for edit: Closed second post
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    19th March 2018 - 01:44 PM