ACCESS 2007 Form Input

SHABZO

Registered User.
Local time
Today, 02:44
Joined
Nov 17, 2013
Messages
24
I am using the Northwind Database example. I have a Product table with a product called Injection1, Injection2, etc

In my order form i have a subform called sbforderdetails and another called sbfvitals.

in the order details form there is a dropdown combo that has all the products . In the sbfvitals there is a control called HGT. The value differs from 1 to 5.4
As long as it is not null I want to automatically fill the line item in sbforderdetails with Injection1.

I managed to do it by copying the control to my order form and called it HGT2.
If not is null(ME.HGT2)then
DoCmd.GoToRecord , , acNewRec
Me.Product_ID = "110"
DoCmd.GoToControl "Quantity"
Call Product_ID_AfterUpdate
end if

The proble is that it loops and continues to fill.

Any help will be appreciated.

The reason to automatically fill is if a user forgets to check sbfvitals and that HGT is not null, the product Injection1 is not entered.
 

Users who are viewing this thread

Back
Top Bottom