I am trying to open the form "frmClients_Mai n" to the record that is specified by the end user. Here is the code:
----------------------------------------------------------
Public Function IDSearch()
'This function allows the user to open the main form to a particular client record.
Dim stSql As String
Dim stInput As String
'InputBox prompts user to enter client ID for the form they wish to open.
stInput = InputBox("Enter Client ID", "Search for Client ID", "Client ID")
'open form to record that matches the client ID entered by user.
DoCmd.OpenForm "frmClients_Mai n", acNormal, , "[ClientID]='" & stInput & "'", acFormEdit
End Function
---------------------------------------------
I’m trying to use a “where condition” to specify this, but when I run the code above I get another inputbox that prompts me to “enter parameter value” for ClientID. If I enter the clientID at this 2nd prompt, then I am able to open the form to the specified record.
Does anyone know what needs to be corrected in the syntax above? I’ve been searching online, but haven’t found any solution that works yet.
Thanks.
1 2426
Never mind, I fixed it. I was referring to a field as "ClientID" when it was actually "Client_ID" (with an underscore).
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: LRW |
last post by:
I'm not exactly sure how to even ask the question, and I know my terminology
is not good as I'm a SQL beginner, but, here goes.
I need to find a way to make an if statement within an array...or, the
"while" portion of a recordset.
The best way I can ask is show what I mean.
http://oscarguy.mechphisto.net/awardbrowse.php
If you go there and select an award (like Best Picture), leave the year
field alone, and select YES and submit,...
|
by: Ralf Wahner |
last post by:
Dear Masters of XML
As I'm new to XML Schema I dare to ask a possibly recurring
question: Given an element <elem> with two attributes @a and
@b. The attributes are bound by the condition, that either both
or none must be present, i.e.
<elem a="val_a" b="val_b"/> or <elem/>
is valid, whilst
|
by: Jacinle Young |
last post by:
Hi all,
I have written the SQL but it doesn't work
db2 "select acode from t1 where (acode) not in (select eid from t2
where iid ='0') and iid ='0'"
select nothing
but the following works
|
by: Tom Louchbaum |
last post by:
Can someonw pls tell me how to reference the Where clause made by the
VBA statement
DoCmd.OPENREPORT "Report",acviewpreview,,where
as a control within the Report itself?
Thanks.
|
by: andro |
last post by:
Hi everybody!
I have several tables from which I want to exract the SAME value (along with
other referenced data).
All the values are in the same column within the tables.
How can I achieve this?
TIA.
Andro
| |
by: Ernesto |
last post by:
Within the scope of one Python file (say myFile.py), I'd like to print
a message on ANY exception that occurs in THAT file, dependent on a
condition.
Here's the pseudocode:
if anyExceptionOccurs():
if myCondition:
print "Here's my global exception message"
|
by: eyalhz |
last post by:
I have this code at button click:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If ListBox1.SelectedIndex() Then
Dim lines As String() = File.ReadAllLines(FileName, FileEncoding)
Dim Line As String = lines(Int(Rnd() * (UBound(lines) + 1)))
Dim Pos As Long = Line.IndexOf(" ")
TextBox1.Text = Line.Substring(0, Pos)
TextBox2.Text = Line.Substring(Pos + 1, Line.Length - Pos - 1)...
|
by: keri |
last post by:
Hi,
Simple version of the question.....
How do I use the where clause of the open form command to show an
account with a matching ID to be displayed when the form is opened?
Eg. I select a record on a continuous form and click and edit button.
The button runs the open form code. I want the APPID of the current
record on the continous form to match the APPID of the record viewed
|
by: santoshsri |
last post by:
Hello,
Is there any by which I can write a SQL to get the 4th largest salary from a table without using "join" and without using "where" clause.
Suppose the table is having two columns : Employee_id, Employee_salary.
Please let me know..
I faced this question in an interview and I did not have any answer for this.
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |