ID Value to Replace (1 Viewer)

[smtazulislam]

I have Text Box that name is PageNo(FK)
tblPages : PGID(PK), PAGENO(TEXT), PAGEREF(TEXT).
Value Like: 1 - Page- 1, PG1

I would like to do something like,
If I enter the VALUE "1" in the textbox then Move curser to display same textbox "Page- 1" Or "PG1"

Any help will be appreciate...

 

[CJ_London]

perhaps use the format property

"Page - "#

use enters 1 and

Page - 1

is displayed

or if a different textbox use the following in the control source

="Page - " & PGID

 

[smtazulislam]

perhaps use the format property

"Page - "#

use enters 1 and

Page - 1

is displayed

or if a different textbox use the following in the control source

="Page - " & PGID

Thank you very much,
Formatting Not work. There I added an example with Page.
But here different Items, I want to do when I enter the code LIKE "1" Then ...Insert text items

 

[smtazulislam]

or if a different textbox use the following in the control source

="Page - " & PGID

Not working error

#Type!

 

[CJ_London]

You are very good at providing vague requirements

Rather than describing what you want, show us - and be consistent in your naming

for example
blPages : PGID(PK), PAGENO(TEXT), PAGEREF(TEXT).
- what is the actual name of your fields PGID or PGID(PK)
and is the PK a numeric or text field?
what does this mean

want to do when I enter the code LIKE "1" Then ...Insert text items

Like is only relevant if using wild card characters

what does

Formatting Not work.

mean? you get an error? doesn't display as required?

 

[smtazulislam]

for example
tblPages : PGID(PK), PAGENO(TEXT), PAGEREF(TEXT).

I have another table That name is tblPayList . and JOIN with table tblPages
TblPages field is : PGID(PK), PAGENO(TEXT), PAGEREF(TEXT).

PGID	PAGENO	PAGEREF
1	PAGE-1	PG1
2	NOTHING	NG
3	NORMAL	NR
4	PAGE-5	PG5

Now tblPayIist field is : PaylistID (PK), PGID(FK), PayDate(Date & Time) PayAmount (Currency)

PaylistID	PGID	PayDate	PayAmount
1	1	01/11/2022	3500 $

NOW, if I enter into field "PGID" "3" in my form "frmPaylist" then can possible to replace text as "NORMAL"
if you have more question lets me know.

 

[CJ_London]

use a dlookup function in another control, or use a combo

=dlookup("PageNo","tblPages","PGID=" & PGID)

if you actually want to replace the value 3 with 'NORMAL' in the same textbox, leave it unbound and in the after update event or maybe the lostfocus event put

PGID=dlookup("PageNo","tblPages","PGID=" & PGID)

you will no doubt need additional code if the user doesn't enter a number or enters a letter

 

[smtazulislam]

use a dlookup function in another control, or use a combo

=dlookup("PageNo","tblPages","PGID=" & PGID)

if you actually want to replace the value 3 with 'NORMAL' in the same textbox, leave it unbound and in the after update event or maybe the lostfocus event put

PGID=dlookup("PageNo","tblPages","PGID=" & PGID)

you will no doubt need additional code if the user doesn't enter a number or enters a letter

Thank you very much. I am trying use replace function with bound textbox AFTERUPDATE event.

Private Sub PGID_AfterUpdate()
Dim dlup As String
dlup = DLookup("PageNo", "tblPageNo", "PGID=" & Me.PGID)
Me!PGID = Replace("Me!PGID", "PGID", "dlup")

End Sub

Have any Idea

 

[CJ_London]

So why did you not use what I suggested?

 

[smtazulislam]

So why did you not use what I suggested?

Use your code. But I forget to mentioned. Not work. I tried it LostFocus and AfterUpdate. tried also Bound and Unbound.

 

[CJ_London]

OK, no idea what 'not work' means. please provide detailed explanation

and step through the code and provide details of any errors

 

[smtazulislam]

OK, no idea what 'not work' means. please provide detailed explanation

and step through the code and provide details of any errors

Okay, can you review. I have uploaded my dB.

 

[CJ_London]

Sorry, No - you won't learn anything. You've asked a question, I've answered it based on the limited information provided.

 

[arnelgp]

y

Thank you very much. I am trying use replace function with bound textbox AFTERUPDATE event.

you can't replace it since the return value of dlookup is a string and PgID on your table is Numeric.

 

[smtazulislam]

you can't replace it since the return value of dlookup is a string and PgID on your table is Numeric.

Sorry. I need it act same textbox.

 

[smtazulislam]

Sorry, No - you won't learn anything. You've asked a question, I've answered it based on the limited information provided.

Before you have a comment, you have to open the dB that based on your suggest I have tried or Not.
I told you, I tried it Bound and Unbound textbox POST#10.