Textbox values Cont'

  • Thread starter Thread starter Fausto
  • Start date Start date
F

Fausto

Chris,
I might sound stupid but I'm new with this stuff.
Can you be a little more specific where should I enter
the code you provided me.
Is it in Data or Event.
Thank you for your patience all.
 
Almost missed this:

I don't see a need to save the model number in a table,
when you can easily get that information anytime you want
it from a query.

Go to Queries, then New. Select Design, then Cancel to
not add any tables. Then View/SQL view. Paste that SQL
code there. Save the query and run it.


You can add a textbox to your form, and in the textbox's
controlsource, use the =Dlookup line below.


Chris Nebinger
 
Chris.
I tried the code and it works the way I expected.
I know you are telling me That I don't need to save
ModelNo in a table but I think I do because Next to IMEI
in Table1< I added a Yes/No CheckMark.
In other words I have to create a report of IMEI's that
have a CheckMark and also I need the ModelNo so we can
identify al the IMEI by ModelNo.

In the report I will have something like this:

IMEI OnHand ModelNo
100870249290 Yes i730

Also the report should count how many i730 I have on hand.

I know is getting complicated but can you help me pls.

Thank you.
 
Back
Top