Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Open form to add record with fielddata from an open form

 
   Database Help (Home) -> Visual Basic RSS
Next:  How to print a multidimensional associative array..  
Author Message
proo

External


Since: Feb 15, 2005
Posts: 1



(Msg. 1) Posted: Tue Feb 15, 2005 11:27 am
Post subject: Open form to add record with fielddata from an open form
Archived from groups: microsoft>public>vb>database (more info?)

How do I open a form to add a record and get the data for 1 field from a
specific field in a open form.

I have used the following code ;

Private Sub Form_Open(Cancel As Integer)

If IsOpen("FrmStam") Then
DebNr.DefaultValue = _
Forms!FrmStam!DebNr
End If

End Sub

When I open the add record form the field DebNr is filled with [#Name?#]
Where do I go wrong ?

 >> Stay informed about: Open form to add record with fielddata from an open form 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
New record with data from other form - I would like to open a addrecord form. In this form I would like teh Field DebNr to be filled with the value of the field DebNr in my (open) form FrmStam. I used the VisualBasic code ; Private Sub Form_Open(Cancel As Integer) If IsOpen("Frm...

how do u open a word file in VB?? - hi, i want to open a word file in my c drive. how do i do that in VB? i want to open it when i click a button. thanx devin

Filtering records using textbox on form - Can I use the value of a bound textbox on an open form, as a criteria in a query. If so what would be the correct code for the SQL. If not how can I hold the required value (number) that is selected by the user from a combo box at startup, so that I can....

DAO 3.6 record locking - Hello, I want to lock users' password records after they log on to a VB6 application. I want to be able to determine who is logged on to the database by polling each password record to see if it is locked or not. (DBF files allowed this sort of ..

Can I Update entire record in SQL ? - Heya, I am working on making a SQL database an exact mirror of a local Access database. I check the .mdb database every few minutes for new entries, if there are new entries, I retrieve them and write them to an exact replica table in SQL. This all work...
   Database Help (Home) -> Visual Basic All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]